Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find Highest Date in a range
Hello
Criteria dates; (Sheet 1) A1 = 01/01/2009, A2 = 31/01/2009 (Sheet 2) A1 to A27 list of dates 01/01/2009 to 27/01/2009 I need a formula that will find cell with the highest date in the range between the criteria dates, and the return the value of the adjacent cell (Sheet 2) Col B. Thank you. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compare number to range; find highest positive difference | Excel Worksheet Functions | |||
Find closest match and return next highest number in range | Excel Discussion (Misc queries) | |||
Rolling up the latest date, criteria of range to compare highest d | Excel Programming | |||
Julian date - find next highest date/number | Excel Worksheet Functions | |||
Find date and copy range based on that date | Excel Programming |