Having a list of values, for example city names, and want to know how many times each unique entry is repeated ?
Here’s a simple solution, using a pivot table.
Make sure your selection is correct, and eventually select in which sheet you want the pivot table to be generated.
Here you are with a pivot table – in below example only with one column
Drag and drop the name of the column with the values you want to count to ROWS
Repeat the operation, drag and drop the column name to VALUES
Make sure the Count of option is selected, and voilà ! You know how many times each unique values appear in your list.