select only non-matching rows
 

I have a sheet with over 58,000 rows of info. Only some rows are duplicates.
i need to remove just the duplicate rows, leaving only one row of any
duplicate data. i.e rows 56 & 57 are the same - leave only row 56. Anybody
know a script to do this??

Thanks, Stacy

select only non-matching rows
 

Use the unique option of Advanced Filter (data=Filter=Advanced Filter)

or look at Chip Pearson's page on duplicates and uniques for other ideas

http://www.cpearson.com/excel/duplicat.htm

--
Regards,
Tom Ogilvy

"fuzzy" wrote in message
...
I have a sheet with over 58,000 rows of info. Only some rows are
duplicates.
i need to remove just the duplicate rows, leaving only one row of any
duplicate data. i.e rows 56 & 57 are the same - leave only row 56.
Anybody
know a script to do this??

Thanks, Stacy