|
Sorting Dates
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 |
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 |
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 |
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 |
That just what I need thanks for you help -- allmad ------------------------------------------------------------------------ allmad's Profile: http://www.excelforum.com/member.php...o&userid=26407 View this thread: http://www.excelforum.com/showthread...hreadid=400404 |
Thank you all for your help.......SORTED :) -- allmad ------------------------------------------------------------------------ allmad's Profile: http://www.excelforum.com/member.php...o&userid=26407 View this thread: http://www.excelforum.com/showthread...hreadid=400404 |
| All times are GMT +1. The time now is 03:37 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com