시작하기무료로 시작하기

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.

이 연습은 강의의 일부입니다

Google Sheets로 하는 마케팅 분석

강의 보기

연습 안내

  • 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!

실습형 인터랙티브 연습문제

이론을 실습으로 바꾸는 인터랙티브 연습 중 하나를 만나보세요

연습 시작