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
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
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks