I would personally use datafilteradvanced filter and unique records, if
you start the procedure from the other sheet it will work

http://www.contextures.com/xladvfilter01.html#FilterUR

same page a little further explains how to apply the filter from another
sheet

or you could use a formula


=INDEX(Sheet1!$B$2:$B$40,MATCH(0,COUNTIF($B$1:B1,S heet1!$B$2:$B$40),0))

where B2:B40 is the list and B2 is the cell where you put the formula (you
always need to refer to the cell above (B1), enter it with ctrl + shift &
enter and copy it down until you get an error


--
Regards,

Peo Sjoblom


"Gary T" wrote in message
...
hi,

I have a list of names that lloks like the following:

George
George
George
George
Stephen
Stephen
Sam
Sam
Ronald
Ronald
Ronald


In another worksheet, I want to display each of the names that appears in
this list.

how do I do this using functions?

Many Thanks,