Hi,

I am wondering what the best way to do a multiple conditional comparison is?

For example I have 3 columns of data where I need the first column compared,
then if TRUE, compare data in the second column which if also TRUE, then flag
the result.

P/N Class Qty
12345 A 3
12345 B 5
12345 C 2
54321 A 4
54321 C 1

So in the above data example, I need to essentially compare the class codes
within the same part number and if the quantity of class "A" is less than "B"
OR "C" (in situations where only one these class codes exist) then place a
flag in "A's" row. However in situations where both class "B" AND "C" exist
for the same part number, I need to flag "A" if it's quantity is less than
the COMBINED quantity of "B" AND "C".

Any help would be appreciated. I'm getting a headache trying to figure out
the forumla.

Thanks.

Ella