| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Return a Value between dates based on another Value
Sample data:
ColA ColB ColC Row1 22 1/16/2009 55 Row2 23 1/18/2009 17 Row3 22 1/20/2009 33 Row4 25 1/23/2009 9 I have several thousand rows with every column a named range, i.e. rng1, rng2, etc. Example: I want to return '55' and '33' from ColC, based on '22' from ColA between the dates 1/1/2009 and 1/31/2009 (ColB). Thx, casey |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| return value based on another value | Excel Discussion (Misc queries) | |||
| Return dates based on month and day of week | Excel Worksheet Functions | |||
| return based on range of dates | Excel Worksheet Functions | |||
| return value based upon another | Excel Worksheet Functions | |||
| return array result in cell based on comparing dates | Excel Worksheet Functions | |||
Threaded Mode
