Excel query a sheet of raw data and return

Hello ,

I hope you're all having a good day so far. I however am not, I'm trying to pull certain data from a spreadsheet of raw data. It's an investment spreadsheet so I have a very large dump of a stock screen. About 2500 companies. I'm trying to make it so every month when I rerun the screen it formats the data automatically. The easiest way for me to do that is have a raw data sheet that I replace every month with fresh data. On the other sheet I need it to pull companies from that sheet with a market cap of say 100 million to 1 billion.

Example:

So how can I query this page to return all companies with a market cap of 10 - 100 Billion and return all the columns of data, or just certain ones I specify. In google docs there is a QUERY function which would work perfectly but these screen dumps are far too large for google docs to handle so I prefer to use excel.

Colums are like this:

Ticker Name Market Cap Computed data1 Computed data2, etc.

IBM IBM 203560894464 Blah Blah

MMM 3M 65359548416 Blah Blah


Thank you very much in advance.