I have two filters on an excel sheet. The filters are 'employee group' and 'employee name'. by default all the groups and all employee names are shown in the filters. When a employee group is selected, the related employee names are shown in white in the employee name filter, and, remaining are highlighted in black/grey.
Is there any way out where when I select a group, the name filter should show only the records related to the selected group??