The Common and known options is to use Advanced Filter to filter "Uniques
Only".
Micky


"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 appreciated.

Many thanks

--
nozzaworld