nmichele
asked on
Blank cells not being counted in Pivot Table
When generating a Pivot Table, blank cells are not being included in a count for blank cells.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
if you want the blank cells to be counted, then there is a workaround to have them counted.
a simple code of macro that changes the blank cells of pivot table data source with putting a space there and then when you pivot , the blanks being the space will work.