Removing duplicate in from two columns not in order.

**bisalk** · 10-02-2013, 02:33 AM

Hi experts,

I have trying to remove duplicate value for two columns which are not in order since long time. I have listed an example for the purpose. Two rows contains same information in different columns. I just wanted to have one row and remove the other with same information. Need a quick help.

AA AA
500135 500136
500136 500135
500137 500138
500138 500137
500191 500192
500192 500191
500277 500278
500278 500277
500413 500414
500414 500413

**Fotis1991** · 10-02-2013, 02:37 AM

Why you don't just delete the second column?

**bisalk** · 10-02-2013, 02:49 AM

Removing second column will be a manual work for huge data and all the rows dont have duplications.

**bisalk** · 10-02-2013, 02:50 AM

These are the pair numbers, deleting one column will not let me know which number is paired to what.. yes but deleting whole row which contains same paring data will be useful.

**Fotis1991** · 10-02-2013, 02:55 AM

Assuming that you date start in A2, in C2 and copy down you can use this.

=A2=B2

Then filter by true in column C, you'll get all cases that data are same in both columns.