-
Continued: pivot table counting blank cells in data table
Hi all,
I'm still battling with a problem.
I have a pivot table which is counting blank cells from the range of data that the pivot table is reading from.
It appears some of the cells have spaces in them so they appear blank in the data range but the pivot table is counting them.
Is their a way I can clear these cells with spaces in, so the pivot table reads them as blank?
Many thanks,
Nicko
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules