-----Original Message-----
I have a spreadsheet with multiple same names. I need to
delete all the duplicates. HELP!
.
Not entirely sure what you need but...
Highlight your names ( I assume they all lie in a single
column e.g A1).
Select<Data><Filter><Advanced Filter>
In the dialog box enter your data in <List Range>
Place a check mark in <Unique Records Only> [found at
bottom of dialog box] and then press <OK>.
This will just give unique records i.e. no duplicates.
Now copy and paste to a different worksheet.
Maybe this is of use...?
