Excel Challenge 13: Use Partial Match to Find Multiple Criteria

How good are you at using Excel filters? 

If you’re not too confident in your skills, maybe some practice is just the thing you need. If you're a spreadsheet whiz, try timing yourself for an added challenge. 

Here’s what to do:

• First, watch the challenge video and read the instructions below the video
• Download the Excel worksheet you will use to complete the challenge tasks
• Put your skills to the test!

Want to chat about your approach and process with other Excel-heads? Join our Slack channel to share your insights and questions with like-minded learners.

The challenge

Here’s the scenario to be solved from the download file:

An online video streaming service has its customer database saved on an Excel worksheet. They want to run a promotion to their customers who have a Basic-level subscription or those who have yahoo email addresses. Can you help them extract those records using Excel filters?

Check out the two videos below if you need a helping hand.

Download the file below to get started.

Team up and chat with other learners and pros on our Slack channel, and stay tuned for the solution. Have fun!

The solution

If you enjoyed this challenge, check out the GoSkills Excel Resource hub for more Excel challenges and blog pieces. Better yet, why not sharpen your Excel courses no matter what level you're at?

We recommend the Basic and Advanced Excel course to help you learn more essential formulas, functions, and practical, real-world Excel skills.