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 |
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 |
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 |
All times are GMT +1. The time now is 10:20 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com