DEllis
Active Member
- Joined
- Jun 4, 2009
- Messages
- 344
- Office Version
- 365
- Platform
- Windows
Hello, I have a spread sheet that has over 500 locations in 3 regions. I am interested in one region and then I want to know if those locations within the one region responded yes/no or some other criteria. I canot figure out how to do this on a pivot table without getting all the totals per option yes/no (i get totals for both and I really only want to see one "no" response).
Is there another way to do this other than a pivot table? I have like 15 criteria that I want to display for each location in that region.
Thank you in advance for all your help
Is there another way to do this other than a pivot table? I have like 15 criteria that I want to display for each location in that region.
Thank you in advance for all your help