Highlight the column where you want unique values (works best with a
header row), then Data | Filter | Advanced Filter. Here you can choose
unique values only, and elect to filter in place or to copy (extract)
the values to another location (you specify where). Click OK and it's
done.

Hope this helps.

Pete