reporting yes results in one column
On Apr 2, 8:55*am, Johnnyboy5 wrote:
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
Why not a simple one click macro to
datafilterautofilterfilter by yescopy to other sheetunfilter
|