ArisaAnsar
asked on
Excel-Pivot Tables
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?
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER