New answers tagged regexextract
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