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
 

Hi Randy,

Look in Help for the LARGE() function

--
Kind regards,

Niek Otten
Microsoft 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

Auto Re-Numbering in Excel
 

Hi,

This assumes your hire dates are in column A starting in A2. Enter the
formula in row 2 of another column and drag down as required

=IF(A2="","",RANK(A2,$A$1:$A$1000,1))

Mike

"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
 

You asked this same question on December 31st over in the
microsoft.public.excel.misc newsgroup and received three responses... did
none of those responses work for you?

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

Auto Re-Numbering in Excel
 

Bonsour® Randy avec ferveur ;o))) vous nous disiez :

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

1 - for hiredate next column, put that formula
=RANK(CurHireDate, HireDatesRange,True)
2 - pull down as wanted

HTH

Auto Re-Numbering in Excel
 

That is pretty much the same answer I gave the OP when he first asked this
question over in the microsoft.public.excel newsgroup on December 31st.

--
Rick (MVP - Excel)


"Mike H" wrote in message
...
Hi,

This assumes your hire dates are in column A starting in A2. Enter the
formula in row 2 of another column and drag down as required

=IF(A2="","",RANK(A2,$A$1:$A$1000,1))

Mike

"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
 

Rick,

I just noticed it's posted 3 times in 'General questions' in the last hour.
I found your post also and see you never got a response. I wonder if we will
this time!!

Mike

"Rick Rothstein" wrote:

That is pretty much the same answer I gave the OP when he first asked this
question over in the microsoft.public.excel newsgroup on December 31st.

--
Rick (MVP - Excel)


"Mike H" wrote in message
...
Hi,

This assumes your hire dates are in column A starting in A2. Enter the
formula in row 2 of another column and drag down as required

=IF(A2="","",RANK(A2,$A$1:$A$1000,1))

Mike

"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
 

Or if we will simply see the question posted again in another two days.<g

--
Rick (MVP - Excel)


"Mike H" wrote in message
...
Rick,

I just noticed it's posted 3 times in 'General questions' in the last
hour.
I found your post also and see you never got a response. I wonder if we
will
this time!!

Mike

"Rick Rothstein" wrote:

That is pretty much the same answer I gave the OP when he first asked
this
question over in the microsoft.public.excel newsgroup on December 31st.

--
Rick (MVP - Excel)


"Mike H" wrote in message
...
Hi,

This assumes your hire dates are in column A starting in A2. Enter the
formula in row 2 of another column and drag down as required

=IF(A2="","",RANK(A2,$A$1:$A$1000,1))

Mike

"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

.