Can I set a cell value to a filter selection in Excel?

  • Thread starter Thread starter TC in CT
  • Start date Start date
T

TC in CT

I have auto filter on for a set of row headers and would like to populate a
cell with the number of rows that match the filter selection. If my row
entries in this column are "Yes" and "No", for example, I'd like to show the
number of "Yes" entries in the column when I filter by "Yes" or "No" when
filtered by "No".

A pivot table is over kill for my solution.

Thanks in advance!!
 
Let's say 'Response' is in A1.
all the Yes and No responses are in A2:A30.
=SUBTOTAL(3,A2:A30)
Filter your list and see what happens.


Regards,
Ryan--
 
You nailed it rguy!! Thanks.

ryguy7272 said:
Let's say 'Response' is in A1.
all the Yes and No responses are in A2:A30.
=SUBTOTAL(3,A2:A30)
Filter your list and see what happens.


Regards,
Ryan--
Click to expand...
 
I searched and found this formula and works as it's noted below, however, so
I can learn how this is done instead of copying, can you tell me what the 3,
reference represents in the formula?
 
Look in Excel help for the SUBTOTAL function. It'll tell you what all the
index numbers mean.
 
You can learn more by typing "subtotal" into the Excel help dialog.


Gord Dibben MS Excel MVP
 
Back
Top