[Solved] Counting duplicates

[dentopolis]

I have a list of Cities where my customers come from. how to display only unique values and count numbers of customers from those cities?
example:
Washington
New York
New York
New York
Washington


I need:
New York | 3
Washington | 2

[Villeroy]

Add a column header on top, say "Cities"
Select the list including that header cell.
Data>PivotTables>Start...
[X] Pivot table from current selection, [OK]
Drag "Cities" to "Row Fields"
Drag "Cities" to "Data Fields", double-click, choose "Count" as function.

[dentopolis]

great.that works!thank you

[thinman3]

Edit: Well, a little late but whatever;

The attached file shows two ways to get the count of the same entries in col. A and describes how to FILTER column A to get a single entry list for entries in column A.

Duplicates, FILTER, COUNTIF.ods

(12.86 KiB) Downloaded 1677 times