match or compare 2 columns to distinguish duplicate data

[gchauhan]

I have spent so much time trying to resolve this, and help is much appreciated.

I have attached a spreadsheet where I have some same and some different data in column a and columnb. I need to sort the data so I can see the same value on the same row.

E.G. I have the below extract:

Party Number Party Number 2
500012281 500021685
500016910 500009119
500021685 500012281

I need it to show as the below to identify the same data in each column

Party Number Party Number 2
500012281 500012281
500016910
500021685 500021685

Here I can see that column2 has two entries that are duplicated in column1, and one entry that has duplicate. Is there a way of soriting and arranging this data?

[UKNinja]

Please Login or Register  to view this content.

This will sort the first column of data (probably not needed), then insert a column to the right. It will then run through each row of column 1 and look for the value in column 3, if found copy the value from col 3 into col 2 and remove from col 3. Repeats for all of column 1, meaning all values left in column 3 are ones without a duplicate in column 1. It then sorts these values into a condensed list.

Any good?

[nilem]

as an option

Please Login or Register  to view this content.