Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Very simple match function help
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Very simple match function help
Thanks Mike! That did the trick. I would have thought it would be simpler
than that though. Mike "Mike" wrote: Try this entered asn an array formula (ctrl+shift+enter) =INDEX(G9:G20,MATCH(MIN(IF(G9:G20-I3=0, G9:G20,FALSE)),IF(G9:G20-I3=0,G9:G20,FALSE),0)) Will that do? Mike "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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Very simple match function help | Excel Worksheet Functions | |||
Very simple match function help | Excel Worksheet Functions | |||
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 |