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
![](https://s2.save4k.ru/pic/r5O7qA9D6Xw/mqdefault.jpg)