reporting yes results in one column

  • Thread starter Thread starter Johnnyboy5
  • Start date Start date
J

Johnnyboy5

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 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
Click to expand...

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.
 
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
Click to expand...

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
 
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
Click to expand...

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.
 
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
Click to expand...

Why not a simple one click macro to
data>filter>autofilter>filter by yes>copy to other sheet>unfilter
 
To OP

As an alternative to Don's macro suggestion............

To use an advanced filter with results to another sheet see Debra's site.

http://www.contextures.on.ca/xladvfilter01.html#ExtractWs

Gord Dibben     MS Excel MVP
Click to expand...

Nice page - thanks

I have tried - the only issue is I have to repeat the setting up of
the Advanced filter - everytime I change the YES NO responses to the
questions - is there a way to save the advanced filter or keep it
active ?

John
 
The method found on Debra's site is not dynamic.

Turn on the macro recorder and follow Don's suggestion of Autofilter, copy and
paste.


Gord
 
Back
Top