count repeated values in excel

Ritkonsult used Ask the Experts™
I have a excel file ( with one column and 5000 rows. Each cell have a value between 1-9999. Many cells have the same value. How do I easily make Excel to tell me how many cell that have a certain number (I do not want to make a formula for every single value I want excel to count).

I simply want a list that tell me how many times value 2 value 2300 etc. is repeated.
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
May be u can use a Pivot Table.
Its a very useful feature in Excel.

a sample of Pivot Table on cell E1:F9


I think the Microsoft instruction was very hard to understand even then I found in my native language (Swedish) but it worked.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial