MS Excel help - Finding and listing Duplicates

[OzyOly]

Hey there,

this is kinda embarrassing but I barely use Excel and I'm stuck.

I'm trying to find the collision in a hash function so I have two columns, A and B, each with 15k+ rows, strings in A, integers in B.

What I want to do it extract a list of AB whose members are those who have matching integers (B's).

I've used conditional formatting to highlight duplicates but copying and pasting each entry by moving through 15k strings is taking a looooong time. Can anyone help?

 

[OzyOly]

What I want is a list of strings and integer pairs where the integers match.

For example,

and 123456
be 123456
hello 12344
world 12344
yo 12344

if you see what I mean? Basically the list of integers that are duplicated with their matching strings?

 

[OzyOly]

Thank you for all your help guys. In the end I had to use a python script to work it out for me as excel kept freezing.