The data contains 263 rows, each with a City and Country.  The pivot table shown is based just one field: City, which has been added as both a Row field and a Value field:

In the Values area, the City field has been renamed “Count” and set to summarize by count :

In the Rows area, the City field is filtered to show only cties where  count is greater than 1:

In addition, the City field is set to sort by count in descending order:



Dave Bruns

Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.   

Pivot table show duplicates - 92Pivot table show duplicates - 13Pivot table show duplicates - 77Pivot table show duplicates - 36