When I set up a spreadsheet with AutoFilter I often insert a row at the top
to show how many rows are displayed by the current filter, e.g. ="Rows
displayed - " & SUBTOTAL(103,A3:A20000)
Now I'm trying to find a way to display the criteria used by the AutoFilter.
e.g. "Rows displayed - " & SUBTOTAL(103,A3:A20000) & " - filter applied:
<the filter(s)>"
Obviously could use an Advanced Filter and create some formula to produce
the <the filter(s)> element above.
Am hoping to find a way to inspect the conditions used in the AutoFilter
and append them to the "Rows displayed..." legend.
Any suggestions?