reporting yes results in one column
On Sat, 2 Apr 2011 09:43:54 -0700 (PDT), Johnnyboy5
wrote:
On Apr 2, 2:55*pm, 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
Thanks - I have been doing some learning and have got an advance
filter to do it - but my issues are now
1 the filter does stay to be used again after it been used once and
the filtered data is in a new sheet
also if I make changes in the main sheet the filtered sheet does "auto
update"
any ideas
John
My method may help, and then you could use a pivot table to show the
results as a single block of info. The pivot table remains through data
alterations.
You should look at mine, if you didn't yet. No pivot table, but not
difficult to add one.
|