To see the unique counts in a pivot table: Create a Pivot Table from this data, with Region in the Rows area. Add Unique, Units and Value in the Values area. Change the "Unique" heading to "Count of Person" or "Person " Nov 8, 2022