Displaying Active Filter Criteria
There is an Excel file that teaches how to perform the Displaying Active Filter Criteria operation.
Excel Spreadsheet for Displaying Active Filter Criteria
This file addresses how applied filter criteria are automatically displayed within a cell. Additionally, which field and value the active filter operates on is dynamically listed. Thus, it is easily understood which filter is active in reports. For this reason, data transparency is increased. Consequently, reporting reliability is strengthened.
Hope it is useful.