If I were you, I would experiment with the powers of "SORTING DATA" This can allow you sort all the date of one column into different types of order.
This way, you can zero in on columns that pertain data.
I use it all the time and it's great.
In 2007, go to "Sort and Filter" Select Custom sort and input the rules you wish to apply.
Let's say, Sort column C, in ascending oder. All irrelevant rows will be sent to the bottom and your Meat, so to speak, will be at the top. Use the isolation of these rows to write formulas on another sheet, or different column. (the formula's should stick if you re-sort the rows according to values of different columns)
Play around with it, and I'm sure you could find a solution there.