I have a large spreadsheet to modify, but have included a small sample (attached) for explanation.
I only want certain rows.
For example, I want Row 2 because there is a # sign in column A beside it. I do NOT want Row 1 because there is a Row 2 where R1C2 matches R2C2.
Another Example: I only want row 8, not row 7 or row 9, because a row exists with G0105 in column B and a # sign in column A.
I DO want the rows 14 through 18, however,because there are no rows where a # sign exists for those identifiers in column B.
So the # sign trumps all, but in addition I want to exclude any rows where there is a value in column C.
Does anyone know how to do this?