Pivot Table or something else

[DEllis]

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

 

[DanteAmor]

Hello @DEllis .

I hope you are well.​

It would be helpful if you could provide us with the sample data from your sheet (use XL2BB tool).
And a sample of the result you want.

Note XL2BB:​

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in​

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.​

--------------
I hope to hear from you soon.
Respectfully
Dante Amor
--------------​

 

[DEllis]

Hello @DEllis .

I hope you are well.​

It would be helpful if you could provide us with the sample data from your sheet (use XL2BB tool).
And a sample of the result you want.

Note XL2BB:​

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in​

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.​

--------------
I hope to hear from you soon.
Respectfully
Dante Amor
--------------​

Thank you, but I just did this manually as it seemed to make more sense and I had way to many options in each column. Appreciate your help