comparing values from a range
Hello,
I'm not sure how to approach this...
I have a report with quite a lot of data. I need to do a couple of things with it.
1) I need to look for all records that have the number 7 in column C that don't have a duplicate entry in column A
Simplified Example
------------------------------------------------------
AB45678902CN somedata 7 somedata somedata
AB45678902CN somedata 1 somedata somedata
2) Separately, I need to search for
Items in column A that do not have a corresponding number 7 entry in column C
In both cases, there should be at least two of each entry in column A.
I really hope I've explained this well enough!
Thanks for your input.
|