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.

=IF(A1=MAX(A:A),A1,"")

and copy down.

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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.
>

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,MATCH(LARGE(A:A,ROW(A1)),A:A,0))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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.
>

"galimi" wrote
> =VLOOKUP(MIN(A1:A7),A17,2,FALSE)&VLOOKUP(MIN(A1:A7),A17,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
---