Thanks for the help Morrigan unfortunately the formula assumes that I
know the most recent date. In my real spreadsheet I have thousands of
patients with 1 to 20 different dates and I want the formula to be able
to find the most recent date of that one patient and their associated
value. Does that make sense? Thanks for helping, Wendi


--
wgechter
------------------------------------------------------------------------
wgechter's Profile: http://www.excelforum.com/member.php...o&userid=30799
View this thread: http://www.excelforum.com/showthread...hreadid=505535