M
Mollie
When using AutoFilter, is it possible to have the text
value of the filter selected inserted into a cell? I am
using Excel to evaluate survey results. I have a
worksheet set up so that filters can be applied to
different columns to look at the data in a variety of
ways. The results of those filters are used to calculate
percentages, such as percent favorable responses from
respondents fitting a certain criteria. Those results are
displayed on a separate worksheet that updates as
different filters are applied. However, I don't know how
to get that worksheet to display the filters that were
selected.
value of the filter selected inserted into a cell? I am
using Excel to evaluate survey results. I have a
worksheet set up so that filters can be applied to
different columns to look at the data in a variety of
ways. The results of those filters are used to calculate
percentages, such as percent favorable responses from
respondents fitting a certain criteria. Those results are
displayed on a separate worksheet that updates as
different filters are applied. However, I don't know how
to get that worksheet to display the filters that were
selected.