Excel Filter Function With RegexTest Function

Published: 27 August 2024
on channel: The Excel Cave

137

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

On this page of the site you can watch the video online Excel Filter Function With RegexTest Function with a duration of hours minute second in good quality, which was uploaded by the user The Excel Cave 27 August 2024, share the link with friends and acquaintances, this video has already been watched 137 times on youtube and it was liked by 11 viewers. Enjoy your viewing!

2,280