working with a long list
 

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

working with a long list
 

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

working with a long list
 

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