Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto Re-Numbering in Excel
Ok.. here's the problem.. I'm re-creating a seniority list for my company.. I
need a column to show an employee's 'seniority number'.. (ex, the employee thats been with our company the longest would be assigned #1.. second longest #2.. etc..).. the problem is when someone quits or retires I have to manually change all the seniority numbers beneith them.. is there any way that Excel can do this automatically for me.. for administrative purposes.. I can arrange employees by hire date.. however our union wants each employees seniority number listed Thanks for any help! -- Randy |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto Re-Numbering in Excel
Use the "rank" function. create a range name based on the column of hire
dates, then have a column with the formula =rank(TheCellToRank,RangeOfHireDates,1) (I'm using words to explain what I mean) "Randy" wrote: Ok.. here's the problem.. I'm re-creating a seniority list for my company.. I need a column to show an employee's 'seniority number'.. (ex, the employee thats been with our company the longest would be assigned #1.. second longest #2.. etc..).. the problem is when someone quits or retires I have to manually change all the seniority numbers beneith them.. is there any way that Excel can do this automatically for me.. for administrative purposes.. I can arrange employees by hire date.. however our union wants each employees seniority number listed Thanks for any help! -- Randy |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto Re-Numbering in Excel
Why not check out the answers you received, in this same newsgroup, when you
asked the same question back on December 31st? -- Rick (MVP - Excel) "Randy" wrote in message ... Ok.. here's the problem.. I'm re-creating a seniority list for my company.. I need a column to show an employee's 'seniority number'.. (ex, the employee thats been with our company the longest would be assigned #1.. second longest #2.. etc..).. the problem is when someone quits or retires I have to manually change all the seniority numbers beneith them.. is there any way that Excel can do this automatically for me.. for administrative purposes.. I can arrange employees by hire date.. however our union wants each employees seniority number listed Thanks for any help! -- Randy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto Re-Numbering in Excel | Excel Discussion (Misc queries) | |||
Auto numbering in Excel | Excel Discussion (Misc queries) | |||
Auto-numbering in Excel | New Users to Excel | |||
is there an auto-numbering tax invoice templete for excel | Excel Discussion (Misc queries) | |||
Is auto invoice numbering possible in Excel 2003? | Excel Discussion (Misc queries) |