Fields
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:
Steps
Author
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.
