=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.