Hello,
I've got 2 columns of data in Excel 2007 that need sorting. There are some duplicates in both columns i.e. some column A data is duplicated in column B and vice versa. Is there an easy way to find and delete the duplicates in both columns?
Thanks
Regan
I've got 2 columns of data in Excel 2007 that need sorting. There are some duplicates in both columns i.e. some column A data is duplicated in column B and vice versa. Is there an easy way to find and delete the duplicates in both columns?
Thanks
Regan