View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
VanS VanS is offline
external usenet poster
 
Posts: 1
Default How do I sort - and count - items in a column?

I have a column like

Grade
A
B
C
A
B
B
C
D
E

and so on. What command shoud I use to sort and get a list of the top
five categories, with a count for each of the five categories, such as
how many A's, B's...?

Thank you.