Display Unique Names From a Long List

Originally Posted by Phillycheese5

I have a list of 2000 stocks in column A and their corresponding country of origin in column B. There are anywhere from 15-30 unique countries on the list. Is there a formula I can use over a range (let's say C1:C30) that will give me a list of the unique countries?

Thanks,
Phillycheese

Hi,

select the column and then Data, Filter, Advanced Filter and select the Unique Records option.

hth
---