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

[Peo Sjoblom]

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


Regards,

Peo Sjoblom

"dwayneh" wrote:

>
> 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
>
>
> --
> dwayneh
> ------------------------------------------------------------------------
> dwayneh's Profile: http://www.excelforum.com/member.php...o&userid=21211
> View this thread: http://www.excelforum.com/showthread...hreadid=376156
>
>

[dwayneh]

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

Dwayne