You appear to have a numeric column at the beginning of each line (column A)
which will enable you to return to your original order. You can sort on the
date (column C), fill column D in numeric order, then sort again using
column A.
--
Ian
--
"allmad" wrote in
message ...

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