count repeated values in excel

Ritkonsult
Ritkonsult used Ask the Experts™
on
I have a excel file (www.jonasson.se/nr.xlsx) 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.
Comment
Watch Question

Do more with

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

http://office.microsoft.com/en-us/excel-help/pivottable-reports-101-HA001034632.aspx

Commented:
a sample of Pivot Table on cell E1:F9
eg-of-Pivot-Table.xls

Author

Commented:
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