You can use Advanced Filter to do this. Assuming your names are in A2
to A2000, with a heading ("Name" ?) in A1, highlight A1 to A2000 then
Data | Filter | Advanced Filter. A panel will pop up where you can
select Unique Records Only and either Filter in Place or Filter to
another location - eg you could select C1. Click OK once you have your
settings and the job's done.

Hope this helps.

Pete

deblars wrote:

I have a long list that I'd liked filter down, but don't know how. I know
how to use the basic filter funtion, but I have a list with about 2000 names
and I'd like to delete the duplicates within the rows. Can anyone help?
--
Deb