Thread: How do i set up a rank function on a list of results?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mike Q. Mike Q. is offline
external usenet poster
  
Posts: 49
Default 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
Reply With QuoteReply With Quote