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.
--
Lori99