Extract AutoFilter Column Values?

[dwayneh]

Hi all,
I have a column of road names, with various repititions of the same
name. I want to extract each individual road name to a separate column
(exactly the same as the Data>Filter>Autofilter command). The column
has about 500 records of 50 unique road names, and its these unique
road names that I want?? Please help, its greatly appreciated!!

Regards,

Dwayne

 

[Guest]

Select the road names, do data>filter>advanced filter, copy to another
location and unique records only


Regards,

Peo Sjoblom

 

[dwayneh]

Thanks Peo, very simple answer but has helped so much!!

Dwayn