Pivot Table showing Percent, Count, and # of missing

[2wheeltraf]

I need to find a pivot table and pivot chart showing the percentages, counts and number of missing data based on the columns Interest1 through Interest5 in the attached excel.

For example, how many 2S, AC, 3C, and Z are there in the table? I figured out how to get the results, but I had to move the data into one column then created a Pivot Table based on that, but I'm trying to get the results without moving or changing the data.


How do I do this?

[stasinek]

Hello,
I remodeled your table a bit. The result is in a PivotTable.
You are using the old version of EX - with newer versions there is a lot of possibilities for this fun