I would like a formula to Rank performers from 1-5, example:

In Column A from A1 down to A100 I have a list of Employees by Name
In Column B from B1 down to B100 I list their employee ID#
In Column C from C1 Down to C100 I have their total amount of sales last
month

I would like to rank each employee on a scale from 1-5 (5 is the highest)
based on their performance. ( i.e. The top 20 should get a 5)

I can't figure this out,
Can you please help?

=ROUNDUP(RANK(C1,$C$1:$C$100,1)/20,0)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"fruitchunk" wrote in message
...
I would like a formula to Rank performers from 1-5, example:

In Column A from A1 down to A100 I have a list of Employees by Name
In Column B from B1 down to B100 I list their employee ID#
In Column C from C1 Down to C100 I have their total amount of sales last
month

I would like to rank each employee on a scale from 1-5 (5 is the highest)
based on their performance. ( i.e. The top 20 should get a 5)

I can't figure this out,
Can you please help?

I would attack this as follows:

1. Rank the employees, presumably by sales, using the Rank function.
2. Divide by the number of employees to get an index value.
3. Multiply by 5

So something like:
=CEILING((RANK(C1,C:C,0))/COUNT(C:C)*5,1)

Regards,
Fred.

"fruitchunk" wrote in message
...
I would like a formula to Rank performers from 1-5, example:

In Column A from A1 down to A100 I have a list of Employees by Name
In Column B from B1 down to B100 I list their employee ID#
In Column C from C1 Down to C100 I have their total amount of sales last
month

I would like to rank each employee on a scale from 1-5 (5 is the highest)
based on their performance. ( i.e. The top 20 should get a 5)

I can't figure this out,
Can you please help?

thanks to all of you