View Single Post
 
Old 03-28-2011, 12:50 PM
struct struct is offline Windows XP Office 2003
Novice
 
Join Date: Mar 2011
Posts: 1
struct is on a distinguished road
Exclamation 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.
Reply With Quote