It sounds like you could use Data|Advanced filter and use the unique records
box.

Debra Dalgleish has a nice instruction page at:
http://www.contextures.com/xladvfilter01.html#FilterUR

dennis34 wrote:

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.

--

Dave Peterson