L
Lori99
I have been using a simple pivot table for several months. I am requesting a
count of cells containing data in that column. This month, for some reason,
the count shows one digit higher than the actual count. When I did a Find on
the column, it said that the character I was looking for was in the header
column. I specified exact case and cell contents in the find dialogue box.
For example, for December I wanted to count the number of cells in a column
that contained the letter "E". The header label is Dec. How can I have the
pivot table not count the column label? I have never had this problem
before. Thanks for your assistance.
count of cells containing data in that column. This month, for some reason,
the count shows one digit higher than the actual count. When I did a Find on
the column, it said that the character I was looking for was in the header
column. I specified exact case and cell contents in the find dialogue box.
For example, for December I wanted to count the number of cells in a column
that contained the letter "E". The header label is Dec. How can I have the
pivot table not count the column label? I have never had this problem
before. Thanks for your assistance.