Forum Discussion
Solved
How do I count the occurrence of unique values?
How do I count the occurrence of unique values for over 1000cells in a column? After getting the answers, is there a short cut for autocomplete without having to drag? I've tried this, doesn't seem...
Or, if you want to count the number of occurrences of each value, create a pivot table based on your column. Add the column to both the Rows area and the Values area.
HansVogelaar Office 365( Excel version: 2006)
Or, if you want to count the number of occurrences of each value, create a pivot table based on your column. Add the column to both the Rows area and the Values area.