If I enter new information into excel eg heights of individual people. How
can I get excel to look at the cells where the data is and then produce a
list of the different heights measured.

Eg heights: 162, 180, 145, 180, 123, 123, 180, 144, 145, 145

I need excel to list values that occur: 123, 144, 145, 162, 180

At this stage I'm not interested in the frequency. I just want excel to
look at my data and say these are the values that occur in the data youve
just entered.