ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Pivot table header column included in calculation (https://www.excelbanter.com/excel-discussion-misc-queries/168495-pivot-table-header-column-included-calculation.html)

Lori99

Pivot table header column included in calculation
 
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


All times are GMT +1. The time now is 07:05 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com