K Kris Jul 29, 2004 #1 I have a spreadsheet with multiple same names. I need to delete all the duplicates. HELP!
G Guest Jul 29, 2004 #2 -----Original Message----- I have a spreadsheet with multiple same names. I need to delete all the duplicates. HELP! . Click to expand... 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...?
-----Original Message----- I have a spreadsheet with multiple same names. I need to delete all the duplicates. HELP! . Click to expand... 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...?
