| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Display value in same row of most recent date in a different column
A B C D
1 3/30/1994 C - 0 2 4/1/1995 C - 0 3 4/15/2003 H - 0 4 5/6/2003 C - 0 I need to Display the value in column B and D corresponding to the row with the most recent date. I realize this seems rather easy, but for the life of me I can't figure this one out. Thank you for any help. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Display value in same row of most recent date in a different column
=IF(A1=MAX(A:A),A1,"")
and copy down. -- --- HTH Bob (change the xxxx to gmail if mailing direct) wrote in message ups.com... A B C D 1 3/30/1994 C - 0 2 4/1/1995 C - 0 3 4/15/2003 H - 0 4 5/6/2003 C - 0 I need to Display the value in column B and D corresponding to the row with the most recent date. I realize this seems rather easy, but for the life of me I can't figure this one out. Thank you for any help. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Display value in same row of most recent date in a different column
One way, assuming dates in col A are real and unique ..
Return from col B for most recent date: =INDEX(B:B,MATCH(LARGE(A:A,ROW(A1)),A:A,0)) Similarly, return from col D for most recent date: =INDEX(D:D,MATCH(LARGE(A:A,ROW(A1)),A:A,0)) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- wrote in message ups.com... A B C D 1 3/30/1994 C - 0 2 4/1/1995 C - 0 3 4/15/2003 H - 0 4 5/6/2003 C - 0 I need to Display the value in column B and D corresponding to the row with the most recent date. I realize this seems rather easy, but for the life of me I can't figure this one out. Thank you for any help. |
|
#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 --- |
| Reply |
| 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 | |||
Linear Mode
