Excel Filter Function With RegexTest Function

Pubblicato il: 27 agosto 2024
sul canale di: 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

In questa pagina del sito puoi guardare il video online Excel Filter Function With RegexTest Function della durata di ore minuti seconda in buona qualità , che l'utente ha caricato The Excel Cave 27 agosto 2024, condividi il link con amici e conoscenti, su youtube questo video è già stato visto 137 volte e gli è piaciuto 11 spettatori. Buona visione!