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: [email protected] Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
