I am running Pivot table in Excel. The spreadsheet contains branch locations and account numbers. There are rows where the account numbers are duplicated numerous times on the spreadsheet.
When I run the pivot table to obtain a count of the account numbers, the duplicate account numbers are double counting. If the acount numbers are listed multiple times, I want it to be counted only once.
Is there a way to do this in excel with a pivot table?