duplicated data

  • Thread starter Thread starter a_evie
  • Start date Start date
A

a_evie

I've a bunch of names and membership code of my fellow home makers...So
how do I run a clean up of all the duplicated names?

I really don't want to go blurry eyed trying to clean up manually

THANX!!
 
Take a look at data>advanced filter, unique records only and copy to another
location
 
THANX for the replies (very quick I must say)...

However...I am absolutely lost!:confused:

I've copied and pasted all their details into the same sheet and was
looking forward to run the advanced filter...
(1) Advanced filter
(2) Copy to Another location _ checked
(3) Unique records only _ checked
(4) List range _ Sheet1!$A$1:$B$198
(5) Criteria range _ I left it blank
(6) Copy to _ Sheet2!

AND I get this message "Your formula contains an invalid external
reference to a worksheet. Verify that the path, workbook, and range
name or cell reference are correct, and try again"

HELP...I know this sounds idiotic...
 
Back
Top