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

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

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" <(E-Mail Removed)> wrote in message
news:1E99562C-DB52-4895-AA2B-(E-Mail Removed)...
> 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