ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   counting entries in a pivot table (https://www.excelbanter.com/excel-discussion-misc-queries/112587-counting-entries-pivot-table.html)

Keith

counting entries in a pivot table
 
I have a Pivot Table based on data provided by a rep. The data shows a
business visited, the department visited the date and what was discussed.

I need to count the number of times the business has been visited.
Unfortunatly because one visit to the business might generate 4 or 5
departments visited I am getting incorrect answers. If he visited a business
twice one visiting 2 departments and the second time 3 then the total I get
is 5 and not 2.

How can I count the number of times he visited the company?


All times are GMT +1. The time now is 03:49 PM.

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