| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can I set a cell value to a filter selection in Excel?
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!! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Can I set a cell value to a filter selection in Excel?
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-- -- RyGuy "TC in CT" wrote: 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!! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Can I set a cell value to a filter selection in Excel?
You nailed it rguy!! Thanks.
"ryguy7272" wrote: 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-- -- RyGuy "TC in CT" wrote: 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!! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Can I set a cell value to a filter selection in Excel?
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? "ryguy7272" wrote: 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-- -- RyGuy "TC in CT" wrote: 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!! |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Can I set a cell value to a filter selection in Excel?
Look in Excel help for the SUBTOTAL function. It'll tell you what all the
index numbers mean. -- Biff Microsoft Excel MVP "Ken" wrote in message ... 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? "ryguy7272" wrote: 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-- -- RyGuy "TC in CT" wrote: 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!! |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Can I set a cell value to a filter selection in Excel?
You can learn more by typing "subtotal" into the Excel help dialog.
Gord Dibben MS Excel MVP On Fri, 16 Oct 2009 09:13:01 -0700, Ken wrote: 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? "ryguy7272" wrote: 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-- -- RyGuy "TC in CT" wrote: 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!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell Selection in Excel | Excel Discussion (Misc queries) | |||
| Cell Selection in Excel | Excel Discussion (Misc queries) | |||
| fraction of records matching filter selection not displayed in sta | Excel Discussion (Misc queries) | |||
| # of Records Shown During Auto-Filter Selection | Excel Discussion (Misc queries) | |||
| validation list - filter based on selection | Excel Worksheet Functions | |||
Linear Mode
