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