LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 2nd 10, 06:47 PM posted to microsoft.public.excel.misc
external usenet poster
First recorded activity by ExcelBanter: Jul 2006
Posts: 213
Default 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!

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Auto numbering in Excel Gregg Y Excel Discussion (Misc queries) 1 April 9th 09 04:02 PM
Auto-numbering in Excel brenda New Users to Excel 4 April 20th 07 05:30 PM
execute auto invoice numbering in excel file tom adeimy Excel Discussion (Misc queries) 1 July 25th 06 02:54 AM
is there an auto-numbering tax invoice templete for excel stepping Excel Discussion (Misc queries) 1 May 27th 06 11:24 AM
Is auto invoice numbering possible in Excel 2003? JODYG35950 Excel Discussion (Misc queries) 1 February 25th 06 06:40 PM

All times are GMT +1. The time now is 02:19 PM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.

About Us

"It's about Microsoft Excel"


Copyright © 2017