Well its working now but not the way I want, When I mean the cells
positions in a list I mean as if the dates were arranged in accending
order but because there not I wanted a quick way of seeing who joined
first and such.
So like from this list of dates this would be there order.
19/05/02 9
23/04/02 4
09/05/02 7
12/05/02 8
13/04/02 2
02/05/02 6
04/04/02 1
17/04/02 3
26/04/02 5
23/05/02 10
But I dont want to manually work out there number by looking at the
dates I want a formula to do it for me.


--
Keno
------------------------------------------------------------------------
Keno's Profile: http://www.excelforum.com/member.php...o&userid=30832
View this thread: http://www.excelforum.com/showthread...hreadid=504956