LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 83
Default Find product from date range

OK, a bit confused Table array on sheet 2
ColA ColB ColC ColD
# St Date end Date code#
1234 1-1-2009 5-31-2009 1111
1234 6-1-2009 12-31-2009 2222
2345 1-1-2009 5-31-2009 1111
2345 6-1-2009 12-31-2009 3333

I would like on sheet one
say
A1= #
B2= Date needing to produce Code #
C2=Code#

Please advsie

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Max Value, Sum Product, Between Date Range Chris26 Excel Worksheet Functions 4 August 4th 09 02:28 PM
Find Last cell in Range when range is date format default105 Excel Discussion (Misc queries) 5 July 7th 09 03:11 PM
Find within Date Range MrRJ Excel Discussion (Misc queries) 4 November 24th 08 06:56 PM
Find the next date for a product Algeraist Excel Discussion (Misc queries) 8 November 20th 08 05:31 PM
find sum if one col = ? within specific date range jrheinschm Excel Discussion (Misc queries) 8 July 5th 06 09:48 PM


All times are GMT +1. The time now is 07:32 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"