| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Very simple match function help
Sort data in Descending order
=INDEX(G9:G20,MATCH(I3,G9:G20,-1)) "Mike K" wrote: Oh Wise Ones, I'm kinda embarrassed by this one but I can't get it to work. If I have =NOW() in I3 and in G9:G20 I have these dates: 2/03/07 3/03/07 4/03/07 5/03/07 ...... 1/03/08 Shouldn't (in J3) =MATCH(I3,G9:G20,1) return 4/01/07? It returns 2/02/2008 I need the get the closest to but more than todays date from that column. Please help Thanks, Mike |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Simple (?) Match question | Excel Worksheet Functions | |||
| index match array function-returning only first match, need last. | Excel Worksheet Functions | |||
| Simple match and link | Excel Worksheet Functions | |||
| Match as well as does not match array function | Excel Discussion (Misc queries) | |||
| Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
Threaded Mode
