Extract AutoFilter Column Values?

D

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
 
P

Peo Sjoblom

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


Regards,

Peo Sjoblom
 
Top