How to group and find count in excel

I have attached an excel file which has several records of a set of entries. I need to find out how many times each type of entry is in the file/column.

Using filters for each and finding the count for each of them separately is not a solution. There are too many such entries.

If I could create a table for this using some kind of function or shortcut, that would be great.
Who is Participating?
Saurabh Singh TeotiaCommented:
You can build a pivot table for it to do what you are looking for..All i did i went into insert -->pivot table and build a pivot table to do what you are looking for..

Enclosed is your workbook for your reference..

Also you can refer to the link for how to create the same step by step..
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.