Hello.

I have a list of people with the following information in columns (first name, last name, email, city, state) and corresponding properties they have purchased (property address, property city, property state). I need to find the top 10 cities and states with the highest number of buyers.

The issue is that there are people who have purchased multiple properties (and thus their names appear on multiple rows), so the count I get now by using a pivot table is higher than it should be (i.e. not filtering out duplicate names). How can I make a pivot table to show me only the unique count of the names of people who have purchased property in each state/city?

Thanks guys!