Excel Filter Function Not In List

Опубликовано: 14 Октябрь 2024
на канале: The Excel Cave
1,955
15

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:
https://amzn.to/3aV9GtL

DISCLAIMER: As an Amazon Affiliate I get a commission for every purchase via these links.


#ExcelFilterFunction
#ExcelFilterFunctionNotInList
#ExcelFilterFunctionInList