| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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, |
|
#2
|
|||
|
|||
|
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, |
|
#3
|
|||
|
|||
|
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sorting names alphabetically when names may start with numbers | Excel Discussion (Misc queries) | |||
| Hidding Macro names and coding | Excel Discussion (Misc queries) | |||
| Tab Names II | Excel Discussion (Misc queries) | |||
| how can I count distinct names in an excel list? | Excel Discussion (Misc queries) | |||
| How can I find the common names in two columns of names? | Excel Discussion (Misc queries) | |||
Linear Mode
