pull specific data to a different sheet

[rp1783]

I asked this in the formulas section, but I think VBA may work better, Here is my question:

I have 2 sheets. On sheet 1 I have numerous columns. One of the columns contains phone numbers, another column contains the name that the phone number is assigned to, or it says "Available". What I'm trying to do is have all of the numbers that show Available pulled into the second sheet. The second sheet will have 2 columns. 1 with the phone number, and the other column will say available for all of numbers (since they will all be available). I thought about using vlookup, but I don't have a unique identifier since not all phone numbers will be on the second sheet. Any suggestions?

Sheet 1 has approximately 85000 rows.

[humdingaling]

i used CSE formula to achieve what your after
i used random generator to show it works no matter then number of available

[skywriter]

Here's a macro solution it takes about 5 seconds to process 144710 rows.