Hi,

I know this is probably either very basic, or impossible, but here is what I want to do. I have a set of serial numbers and each serial number can have various "types" assigned to it, I need a macro that can look at the data set highlight or somehow alert me if a serial number has type X but does NOT have type Z, here's a sample of what the data set could look like though the data i'm looking at will have close to 60,000 records.

type serial number
X 1
X 2
X 3
X 4
X 5
X 6
Y 1
Y 3
Y 4
Y 5
Y 6
Z 3
Z 4
Z 5
Z 6

The way I'm doing it now is I would delete the y's highlight the Z's, sort by serial number and look for any gaps in my stripes but thats quite tedious on a large data set so I'm thinking there's a macro that could do this for me.

Thanks in advance!