Displaying names only once

G

Gary T

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,
 
P

Peo Sjoblom

I would personally use data>filter>advanced 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,Sheet1!$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
 
F

Franz

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.
Click to expand...


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
 
Top