Create list of Unique values based on Worksheet Data

[todmac]

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.