+ Reply to Thread
Results 1 to 3 of 3

pivot table counting blank cells in data table Continued

  1. #1
    Forum Contributor
    Join Date
    06-30-2008
    Location
    london
    Posts
    108

    pivot table counting blank cells in data table Continued

    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

  2. #2
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,577
    If the only blanks you expect in those rows or columns are the ones in the "blank" cells, e.g. the others are single words or numbers, you can highlight them and do a Find and Replace to remove blanks.
    ChemistB
    My 2

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  3. #3
    Forum Moderator dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,867

    Smile

    Cross posted
    http://www.vbaexpress.com/forum/showthread.php?t=22404
    Please familiarise yourself with the rules before posting. You can find them here.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. pivot table counting blank cells in data table
    By nicko54 in forum Excel General
    Replies: 4
    Last Post: 09-23-2008, 11:26 AM
  2. Pivot table via external data sourse (cvs)
    By JoannaP. in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-17-2008, 01:53 PM
  3. Replies: 1
    Last Post: 09-16-2008, 04:11 PM
  4. Extracting Data from a Pivot Table and comparing
    By mwburne@yahoo.c in forum Excel General
    Replies: 1
    Last Post: 10-19-2007, 08:31 AM
  5. Pivot table: repeat row data in all cells
    By jmwismer in forum Excel General
    Replies: 0
    Last Post: 02-25-2007, 05:44 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1