Рет қаралды 1,686
This video covers setting up a Filter Function in Excel that returns all records "not" found in a list of values. This is achieved by incorporating the IsNumber and Match Functions into the Filter. The end of the video also shows how to change the output to include anything that "is" in the list.
Purchase a Microsoft Office 365 Personal Subscription with this Amazon link:
amzn.to/3aV9GtL
DISCLAIMER: As an Amazon Affiliate I get a commission for every purchase via these links.
#ExcelFilterFunction
#ExcelFilterFunctionNotInList
#ExcelFilterFunctionInList