Skip to content

Email Newsletter Challenge 20

This week’s challenge is a tough one. It will test your knowledge of three separate functions.

Think you’re up to the task? Download the spreadsheet challenge using the links below.


This week, your task is to write a formula that will return only those data records where the search text is found within the description.


The solution to this problem is quite involved. So instead of writing a long complicated post about it, check out the video below. I cover all the details you need to know.

By the way, the solution is the same for both Excel and Google Sheets.

If you still have questions, please leave me a comment below so I can clarify things for you. I’m here to help! 😊

I hope you had fun, felt challenged and learned something new. And if you’re not signed up for my weekly email newsletter, you can sign up right here!

This Post Has 0 Comments

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Back To Top