Remove dup entries in 2 columns 70,000+

[Guest]

I need to remove duplicates in 2 columns with 70,000+ cells. I cannot combine
into one column because excel doesn't allow me to do so. I need something
that will work in a timely fashion.

 

[Jan Karel Pieterse]

Hi Platanoprincess,

I need to remove duplicates in 2 columns with 70,000+ cells. I cannot combine
into one column because excel doesn't allow me to do so. I need something
that will work in a timely fashion.

Data, filter, advanced filter, copy to another location, unique entries only?

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com