How To Extract A Dynamic List With A WildCard In Excel

In this tutorial we will look at how to extract a dynamic list using a wildcard in Excel. I've done seven previous tutorials on extracting a dynamic list. You can find a link to those here:

To download the file and follow along, go to the link on my website at:

Do you need help with a formula or an Excel project?
Including a sample file is always helpful!

You can donate to my channel through any of the following:

PayPal:

Zelle or Venmo:

[wayneedmondson]

Hi Mike. Nice solution! If the user has Microsoft 365, can use the new FILTER function, as in: =FILTER(H2:H12, ISNUMBER(SEARCH(J1, H2:H12)), "Not Found") and all the results spill down dynamically. Thanks for sharing your tips.. always interesting and useful :)) Thumbs up!!

[karideters]

Hi Mike, These videos have helped me so much. I know a few years back, you had this post, but someone in the comments asked about extracting a list with a wildcard without any duplicates but since your website is no longer up I couldn't find it. I was wondering, if I want to create a unique list that contains a phrase that doesn't contain any duplicates, how would I add to this formula?

Thanks! :)

[kabwechola]

Thank you for this easy to follow video. How can i extract data from multiple column using this approach? kindly help.

[aisabrine]

Formula is not working if row moves. Idk why 😢