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.

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

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



On Dec 21, 9:37 am, VanS wrote:
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.