Aan de slagGa gratis aan de slag

Filter table using REGEXMATCH

Your marketing director wants a list of only the competitor campaigns on their desk in an hour. Though this is last notice, you know that you can combine your knowlege of regular expressions and the FILTER() function to get the refined list to your marketing director in the next hour.

In this exercise, you will be combining the functions FILTER() and REGEXMATCH() to generate a list of only the competitors campaigns. This exercise will help develop your understanding of how useful regular expressions are, as they can take care of minor mistakes in the spelling or structure of the campaign names - if the regex is set up properly, of course.

Deze oefening maakt deel uit van de cursus

Marketing Analytics in Google Sheets

Cursus bekijken

Oefeninstructies

  • Write the appropriate regular expression in cell H2 that will return all competitor campaigns (i.e. campaign names containing Competitors or Competitor).
  • In cell G5, add the REGEXMATCH() function using the campaigns column as the cells of interest and cell H2 as the regular expression.
  • Wrap the REGEXMATCH() function written in the previous step with a FILTER() function to filter for the entire table. Don't forget to provide the range to filter in your FILTER() function!

Praktische interactieve oefening

Zet theorie om in actie met een van onze interactieve oefeningen.

Begin met trainen