Sorting Dates

A

allmad

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
 
I

Ian

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.
 
J

Jon Quixley

Mark,

I assume that you have your dates in a column next to the name and tha
you do no twant to disturb the order of the date/names. In the nex
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 wit
respect to all the dates in cells B1 through to B50. Copy this formul
down from C1 to C50 (remember to include the dollar signs in th
formula !

Jo
 
Top