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:
https://insider.microsoft365.com/en-u...
Learn more about Excel Functions & Features with this book at Amazon:
https://amzn.to/3xtLmXp
Get 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.
#ExcelWildcardFilterFunction
#ExcelFilterFunctionWithRegexTest
#ExcelFilterPatternMatches
Смотрите видео Excel Filter Function With RegexTest Function онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь The Excel Cave 27 Август 2024, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 13 раз и оно понравилось 1 людям.