Aug 12 2021 03:06 AM
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 to work ( =COUNTIF($B$2:$B$3794,B2 ). Help.
Aug 12 2021 03:17 AM
Which version of Excel/Office do you have? Excel in Microsoft 365 has a new function UNIQUE that will return a list of unique items in a range. COUNTA(UNIQUE(...)) can be used to count unique items.
Aug 12 2021 03:32 AM
@Hans Vogelaar Office 365( Excel version: 2006)
Aug 12 2021 03:47 AM
Aug 12 2021 03:49 AM
SolutionOr, 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.
Aug 12 2021 03:49 AM
SolutionOr, 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.