Date: prev next · Thread: first prev next last
2018 Archives by date, by thread · List index

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?

Alan Boba
CISSP, CCENT, ITIL v3 Foundations 2011

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
Privacy Policy:


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.