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.