| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Display value in same row of most recent date in a different colum
"galimi" wrote
=VLOOKUP(MIN(A1:A7),A1:D7,2,FALSE)&VLOOKUP(MIN(A1: A7),A1:D7,4,FALSE) Based on the OP's spec: ... corresponding to the row with the most recent date. should the MIN be MAX instead ? -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Recent documents don't display | Excel Discussion (Misc queries) | |||
| Display Recent | New Users to Excel | |||
| How do I display the most recent "modified" date in Excel sheets? | Excel Worksheet Functions | |||
| i NEED TO PULL OUT THE MOST RECENT DATE FROM A COLUMN- | Excel Worksheet Functions | |||
| How to find the most recent date in a column based on other column | Excel Worksheet Functions | |||
Threaded Mode
