| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Match Function And Display Row Number
Hello -
I have a data set similar to below Date Field 1 Field 2 Field 3 1/1/09 x x o 1/2/09 o x x 1/3/09 o o x I have another field which auto-populates today's date when the workbook is refreshed. The formula for that is: =TEXT(TODAY(),"mm/dd/yy") I would like to use Match to find the row with the closest date to todays date. Any help would greatly be appreciated. Thank you for your time. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need a function to return EXACT row number of a match | Excel Worksheet Functions | |||
| Cross match data in Col A v/s Col B and display match in Col 3 | Excel Discussion (Misc queries) | |||
| Function to find/display the date X number of days later? | Excel Worksheet Functions | |||
| Display missing Part Number if Column A does not match column B | Excel Worksheet Functions | |||
| How do I display more than one match in a Index/Match formula? | Excel Worksheet Functions | |||
Threaded Mode
