reporting yes results in one column
On Sat, 2 Apr 2011 06:55:19 -0700 (PDT), 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
I do not know about better, but here is a quick stab you can play with
and morph as needed:
xttp://www.mediafire.com/file/mf56vs4tu24ync0/QueryResultShow.xls
You have to replace the xttp with http.
|