Create list of Unique values based on Worksheet Data

Hello Everyone,
I have a worksheet with a whole bunch of locations in it (they all appear multiple times )
I would like to create a list of each location ( appearing just once ) to build a lookup table from.

Can someone help me with the quicket and easiest way to do this?

Thank you.

1) Highlight the column of values
2) Activate the Data > Filter > Advanced Filter
3) Copy to another location > Unique Values only

todmac,

You could use AdvancedFilter Unique.

If column D had a title locations, you could highlite column D

Click on Data

Filter

Advanced Filter…

Click on the radio button Copy to another location

In the Copy to: box type in N1

where N1 is an available blank column

click on the box for Unique records only

And, click on the OK button.

There is your unique list of locations.