Thread: assigning class standing based on grade
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Jon Peltier Jon Peltier is offline
external usenet poster
  
Posts: 6,582
Default assigning class standing based on grade
Suppose the percentages are in A2:A20. In B2 enter this formula:

=RANK(A2:$A$2:$A$20)

and fill this down to B20.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Christopher" wrote in message
...
I have a column that contains students grades as a percentage. I want to
have another column that shows their class standing based on that
percentage.


Reply With QuoteReply With Quote