Assuming your dates are in B1:B4

=RANK(B1,$B$1:$B$4,1)

& copy it down

"allmad" wrote:


I am trying to make a list in which the senioraty order is filled in
automatic, and was woundering if there is a function or formula that
will do this.

1 Smith A 24/05/2003 3
2 Rose M 01/06/1987 2
3 Brown D 29/12/2005 4
4 Fisher W 15/10/1976 1

The Numbers in red donates the senioraty order in which they started.
The problem I have is I dont want to alter the rest of the list by
sorting function

Mark


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