Mark,

I assume that you have your dates in a column next to the name and that
you do no twant to disturb the order of the date/names. In the next
column enter the following formula:

=rank(b1,$b$1:$b$50,1)

Where column B contains the date information from B1 to B50 inclusive.
The answer you should get is the ranking of the date in cell B1 with
respect to all the dates in cells B1 through to B50. Copy this formula
down from C1 to C50 (remember to include the dollar signs in the
formula !

Jon


--
Jon Quixley
------------------------------------------------------------------------
Jon Quixley's Profile: http://www.excelforum.com/member.php...o&userid=25803
View this thread: http://www.excelforum.com/showthread...hreadid=400404