Morrigan just took a VERY courageous move by opening a file from someone he
COULD NOT TRUST!!! Please recognize his RISK by giving him a 'Yes' to his
helpful post.!!!
Morrigan, you've just risked/lost one of your nine lives. Hope your LUCK
continues!
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.


"wgechter" wrote:


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