Ritkonsult
asked on
count repeated values in excel
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.
I simply want a list that tell me how many times value 2 value 2300 etc. is repeated.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
a sample of Pivot Table on cell E1:F9
eg-of-Pivot-Table.xls
eg-of-Pivot-Table.xls
ASKER
I think the Microsoft instruction was very hard to understand even then I found in my native language (Swedish) but it worked.
http://office.microsoft.com/en-us/excel-help/count-occurrences-of-values-or-unique-values-in-a-data-range-HP003056118.aspx