Hello, I have a column filled with a long list of text, with the same entries
repeated several times, i.e.:

golf
soccer
soccer
golf
tennis
golf
biathlon

Is there a worksheet function that lets me specify a range of cells and
returns a list of the text values that appeared in the range, i.e:

golf
soccer
tennis
biathlon


This seems like something a lot of people would want to do so I imagine
there's a function for it, I haven't been able to find it though. Any help
would be appreciated.

Thanks