reporting yes results in one column

[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

 

[The_Giant_Rat_of_Sumatra]

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.

 

[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

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

 

[The_Giant_Rat_of_Sumatra]

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.

 

[Donald Guillett]

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
data>filter>autofilter>filter by yes>copy to other sheet>unfilter

 

[Gord Dibben]

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

 

[Johnnyboy5]

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

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

 

[Gord Dibben]

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