Level 3REGEXPractice, 3 min
REGEXMATCH inside FILTER: find the questions
The task
Question-style searches make great FAQ and blog topics. In D2, use
FILTER with REGEXMATCH to list the search terms that start with how, what, why, can, does or is, followed by a space.The data
The starting sheet. Cells outlined in green are where your formulas go.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Search term | Clicks | Question terms | |
| 2 | how to clean suede boots | 48 | ||
| 3 | suede boots | 312 | ||
| 4 | waterproof hiking boots | 187 | ||
| 5 | what size boots for wide feet | 36 | ||
| 6 | boots near me | 95 | ||
| 7 | can you resole boots | 22 | ||
| 8 | best winter boots | 141 | ||
| 9 | why do boots squeak | 17 | ||
| 10 | boot socks | 63 | ||
| 11 | does suede stain in rain | 29 |