Ranking summary data.

  • Thread starter Thread starter JANET BRUMLEY
  • Start date Start date
J

JANET BRUMLEY

I am keeping track of volunteer working hours and want to rank them in order
of their time. The person with the rank of 1 has the highest hours served
and the lowest rank with the fewest hours.

Can anyone help

Ken
 
Assume your hours occupy the range A1 to A10 - the following formula
entered into B1 and copied down will do this:

=RANK(A1,$A$1:$A$10,0)

Hope this helps.

Pete
 
Back
Top