Is there an easier way to erase duplicate entries in a column, other than indivudally?
G gforr Jan 20, 2005 #1 Is there an easier way to erase duplicate entries in a column, other than indivudally?
J JE McGimpsey Jan 20, 2005 #2 gforr said: Is there an easier way to erase duplicate entries in a column, other than indivudally? Click to expand... 1) You could use a macro - post back with a bit more detail if you want to go that route 2) You could do and advanced filter, copying unique values to a new location. 3) You could ease the identification of duplicates by following the guidance at http://cpearson.com/excel/duplicat.htm Chip has a follow-on link for deleting duplicate rows using a macro: http://cpearson.com/excel/deleting.htm
gforr said: Is there an easier way to erase duplicate entries in a column, other than indivudally? Click to expand... 1) You could use a macro - post back with a bit more detail if you want to go that route 2) You could do and advanced filter, copying unique values to a new location. 3) You could ease the identification of duplicates by following the guidance at http://cpearson.com/excel/duplicat.htm Chip has a follow-on link for deleting duplicate rows using a macro: http://cpearson.com/excel/deleting.htm
