Something like:

=Max(If($C$1:$C$100="cross country skiing",$A$1:$A$100))

Adjust ranges to suit and change text string to cell reference
containing the text string...

Then confirm formula with CTRL+SHIFT+ENTER not just ENTER. You will see
{ } brackets appear around it..

Note: You may have to format the result cell as Date


--
NBVC

Where there is a will there are many ways.
------------------------------------------------------------------------
NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=75178