Compare 3 column values wit other 3 column values?

[jamiguel77]

hi all
i have this:

4 AA 100.67 1 FF 310.21
2 BB 210.56 3 GG 119.12
1 FF 310.21 2 BB 210.56
3 HH 119.12 4 AA 100.67


if you see, all 3 first columns exist on the other group... right

Except

3 HH 119.12

and

3 GG 119.12


how to detect this?


thanks

 

[JLGWhiz]

Re: how to compare 3 column values wit other 3 column values?

Thanks, Understand now.

Really much thanks.

You're welcome,
regards, JLG

 

[markmzz]

Re: how to compare 3 column values wit other 3 column values?

Thanks, Understand now.

Really much thanks.

You are welcome and I'm glad to help.

Markmzz