| 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!! |
| 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 | |||
Threaded Mode
