I have a very small table of 22 questions which only require YES NO
replies in one column.

How to I either make a pivot table report to just show the YES.


Or set up an advanced filter to a new sheet which just shows yes
results


or is there a better way ?


Thanks


John