How remove duplicate from both columns

**nexus888** · 03-10-2012, 12:12 PM

Hi
How do I remove all duplicates from both columns.
Eg.

a b
b d
c f
d
e
f
g
h

So I end up with this.

a
c
e
g
h

Thanks
nexus

**dilipandey** · 03-10-2012, 12:44 PM

Hi Nexus,

Welcome to the forum.

See the attached file with solution and description. Thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

**nexus888** · 03-10-2012, 12:57 PM

Thanks but can you pls give me instructions how to set that filter up ?

**dilipandey** · 03-10-2012, 12:59 PM

sure....

Select the three columns and press key combination (Alt + D + F + F).

Regards,
DILIPandey

<click on below 'star' if this helps>

**nexus888** · 03-10-2012, 01:03 PM

OK thanks but do you know if there a faster formula I can use.

My data in column A is 600K lines and in column B it's 100K.
So far after 5min, it has only process 1%

**dilipandey** · 03-10-2012, 01:07 PM

not sure about this.. but I believe this should work fast... suggest you to first enter the formula to complete data and then turn the automatic calculation on Manual and then delete the rows. Thanks

Regards,
DILIPandey

<click on below 'star' if this helps>