Displaying names only once
 

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,

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,

"Gary T" ha scritto nel messaggio


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.


You can use Advanced Filter with a check in the checkbox in the dialogbox
(it should sound as "Unic Copy of records", but I'm not sure becauseI'm not
using English version of Excel... :-) )

--
Hoping to be helpful...

Regards

Franz

----------------------------------------------------------------------------------------
To reply translate from italian InVento (no capital letters)
----------------------------------------------------------------------------------------