Excel Filter Function With RegexTest Function
ฝัง
- เผยแพร่เมื่อ 31 ต.ค. 2024
- This video looks at the new RegexTest Function in Excel 365 and how to use it with the Filter Function for dynamic wildcard searches. These two functions combined can produce all sorts of pattern matches with the filter function such as : Begins With, Ends With, Contains, List Criteria, Or Criteria, Number Patterns, etc.
Note: The Regextest Function is only available to 365 users who have the insiders version. If you have 365 and want to get the insiders version, it's completely free to do. The link on how to do this is below:
insider.micros...
Learn more about Excel Functions & Features with this book at Amazon:
amzn.to/3xtLmXp
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.
#ExcelWildcardFilterFunction
#ExcelFilterFunctionWithRegexTest
#ExcelFilterPatternMatches