How do i set up a rank function on a list of results?
 

i have a column which sums up all the sales my consultants have made, and i
want to rank them in order of biggest sales to least sales. How en earth do i
do that?? Please send me an example.

Many thanks

How do i set up a rank function on a list of results?
 

Hi Maurice

If your sum of all the sales are in column E and you have 12 sales people,
in F1 type: =RANK(E1,$E$1:$E$12). Drag this formula down to F12
and you will have your rankings.

Mike Q.

"Maurice" wrote:

i have a column which sums up all the sales my consultants have made, and i
want to rank them in order of biggest sales to least sales. How en earth do i
do that?? Please send me an example.

Many thanks