How I can pair two cells that have the same value in different columns

[scrzzt]

I apologize in advance for my poor English.

How I can pair cells from different columns based on the same (exact) value (number).
Similar numbers are repeated in both columns, but I need to write in column C which number from column B has its pair anywhere in column A.
The table is large and can be several hundred pairs.

example3.jpg

One pair = one unpaired number anywhere in column B and the first same unpaired number from top to bottom in column A.

As a rule, each number from column A will be paired with the number in column B, but not every number from column B will be paired with the number in column A. Column B will contain more numbers (row) than column A.

[6StringJazzer]

It looks like when you say "pair" you mean that a number in column A can only be paired once, but your data doesn't give an example of this. I assume that if you had one more 100 in column B, it would be paired, but if you had a fourth 100 it would not. Put this in C3 and copy down:

=IF(COUNTIF(A:A,B3)>=COUNTIF(B$3:B3,B3),"PAIR","")

[scrzzt]

OMG! This works...
I tried everything but I didn't even think about this ...

Thank you very much

Best regards

[6StringJazzer]

I am glad to help! Thanks for the rep.

If your question has been answered please mark your thread as "Solved" so that members will know by looking at the thread title that your problem is solved. Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."

[scrzzt]

I added one small thing to make the formula more appropriate for me.

=IF(AND(COUNTIF(A:A;B3)>=COUNTIF(B$3:B3;B3);B3<>"");"PAIR";"")

Thanks a lot again.