New answers tagged

1

Use filter() to get the values that match a regular expression, converting numbers to text strings with trim(), like this: =filter(E3:E105, regexmatch(trim(E3:E105), "\.\d*2$")) To learn the exact regular expression syntax used by Google Sheets, see RE2.


Top 50 recent answers are included