![]() |
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