# How to filter to show data that contain numbers greater or equal to "x"?

I have a google sheet with data that contains a column that is mixed both with text and numbers. I want to filter all to see which have numbers greater or equal to \$500,000.

or which column have the format of '\$ Volume: \$xxx,xxx' that is >= \$500,000.

Example of my data column D:

\$xx \$100.00 Jul 15 2022 Daily \$ Volume: \$132,707 Volume: 100

\$xx \$100.00 Jul 15 2022 Daily \$ Volume: \$500,000 Volume: 100

• Share a link to the spreadsheet (or to a copy of it) so that the volunteer contributors here have sufficient data, a place to test and the ability to know other important specs of the spreadsheet at a glance. Jun 20, 2022 at 19:45
• Added as requested. Jun 20, 2022 at 20:48
• It seems by the fact that you've checked a reply as "Best Answer" that you've now got the solution(s) you were looking for. Jun 21, 2022 at 21:05

I replied over on reddit, but either of these will do it

``````=ARRAYFORMULA(
FILTER(
{A2:A,D2:D},
--REGEXEXTRACT(D2:D,"Volume: (.*) Volume"))
``````

or if you want to use your filter views, use this in another column

``````=ARRAYFORMULA(
IF(ISBLANK(A2:A),,
--REGEXEXTRACT(D2:D,"Volume: (.*) Volume")>=500000))
``````

As I didn't understand how you would like to highlight those rows which contain values> = 500000, I chose to highlight them with conditional formatting using this formula:

``````=value(regexextract(D2,"\\$\w*:\\$(\d*,\d*)"))>=500000
``````

To highlight matching rows in the sheet directly, use this conditional formatting custom formula rule for the range `A2:E`:
`=regexmatch(Sheet1!\$D2, "\\$[5-9][\d,]{5,}")`
To extract matching rows to a new tab, Insert > Sheet and put this `filter()` formula in cell `A2`:
`=filter( Sheet1!A2:E, regexmatch(Sheet1!D2:D, "\\$[5-9][\d,]{5,}") )`