This video displays how to combine the SWITCH Function with the FILTER Function in Excel for a filter that looks at multiple data sets based on Switch criteria. In this example there are 3 tabs containing loan detail information for 3 different bank branch locations. The objective is to combine the two functions so that a filter can be performed on any of the 3 tabs/data sets based on the Switch Criteria branch selection.

#ExcelFilterFunctionWithSwitch
#ExcelFilterFunctionHacks

свернуть