One way to do it would be to add a 'helper' column. Assuming the names are
in column A on the sheet and begin in row 2, put this formula into an
available cell in row 2:
=COUNTIF(A:A,A2)
Fill the formula down to the end of your names list. Use Data -- Filter
and choose 1 to leave only the truly unique entries displayed. Copy all that
is displayed and paste into another sheet. Remove the data filter on the
original sheet and delete ALL rows of information, go back to the other sheet
and copy the list back into the original sheet. For cleanup, also delete the
helper column.


"nozzaworld" wrote:

I am using excel 2002. I have a row of data, with some duplicated records. I
want to be able to delete ALL duplicates.

e.g.
bob
bob
scott
john

would delete all record of bob leaving just the following:

scott
john

How can I achieve this? Any help will be greatly apprenciated.

Many thanks

--
nozzaworld