Hi, Could someone please tell me how to do this simple search. I don't know much programming and this is beyond me. But I think it should be a simple find-if loop?

Thanks so much. File below has my query

# need to perform

# if for each value j (X, Y, Z) in column2, value i in column1 = A and B and C and D, then output value j

# so in this example, I should only get 'X' as the output

# as only X has rows with all four value i (A and B and C and D)

A X

A X

B X

C X

D X

D X

D X

A Y

A Y

B Y

A Z

B Z

C Z

C Z

C Z

C Z

C Z

C Z

C Z

Thanks so much. File below has my query

# need to perform

# if for each value j (X, Y, Z) in column2, value i in column1 = A and B and C and D, then output value j

# so in this example, I should only get 'X' as the output

# as only X has rows with all four value i (A and B and C and D)

A X

A X

B X

C X

D X

D X

D X

A Y

A Y

B Y

A Z

B Z

C Z

C Z

C Z

C Z

C Z

C Z

C Z

## Comment