find addresses of multiple rows in a range

[blue333]

Hi

I am writing a macro which needs to find the references of certain rows where the column contains a formula to determine if that row should be selected or not. If the row is to be selected then the formula displays 'yes' and displays 'no' if it should not be selected. I do can this if the data set is small. However, my data set is huge so using the conventional approach (ie, loop through all rows to find the ones that should be selected) fails. Excel 2007 running on Vista Core 2 Duo with 3GB RAM crashed with a 'small' data set of 80,000 rows by 5 columns.

Using a countif(range, "yes") yields 329 so there are only 329 (out of 80,000) rows I need addresses for. All the functions that find items only return single, not multiple, occurances of a target. If I can get those Excel formulas to return all occurances then I have what I need...but I don't know how to do that.

Does anyone have any suggestions to implement (either functions or macro) what I am looking for that works with huge data sets?

Thanks in advance for your help!!!

 

[jim may]

Furnish some sample data with examples of what shoud be extracted