How do I sort - and count - items in a column?

[VanS]

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.

 

[ankur]

Hi There,

Just do a Data>> Sort and sort it. And then use an Countif function to
count the number of A , B , Cs and so on.

Regards
Ankur
www.xlmacros.com