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
ADDED LINK TO SHEET: https://docs.google.com/spreadsheets/d/1PhQhkM6JxEJjHhiGIrWzMilwNwupAemrvcBVliRAB_I/edit?usp=sharing