Let's say your header in row 1
and names in A2:A2000
create a dummy column
In B2 =COUNTIF($A$2:A2,A2)=1
Copy down as far as needed
In the menu DataFilterAutoFilterfilter all the FALSEmenu Edit Delete


"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