Formula to creating a List from a list of data

[isaacghouston]

Help!!!
I'm wanting to know how to create a list of names that apprear from another sheet under a header called Names. The new list should only pull the names once. Example below are the source names.

A1 Names
A2 John
A3 Bob
A4 John
A5 Nancy
A6 Greg
A7 John
A8 Greg

The other sheet will have my final list of names (without duplicates)as:

C1 Names that appreared
C2 John
C3 Bob
C4 Nancy
C5 Greg

If you know a formula that can pull only the names once, from a list of names that appear on a source column from a seperate sheet please let me know.

 

[ravishankar]

Hi
select the list in col A. Goto DATA menu > Filter > Advanced filter > Tick copy to another location > Copy to = B1 > Click unique records only > Click OK This gives you list of unique names. Copy them to the sheet you want.
Ravi

 

[stuckagain22]

I have a method for doing it, but it takes multiple columns. These columns could either be hidden or on a seperate worksheet that is hidden. Here is what I would do. (Perhaps there is an easier way though?)

Column F is where the names are listed
Column E: =IF(COUNTIF($F$1:F1,F1)>1,"",F1)
Column D: =IF(E1<>"",1,"")
Column C: =IF(D1=1,SUM($D$1:D1),"")
Column B: =IF(ROW(A1)<=MAX($D$1:$D$8),VLOOKUP(ROW(A1),$C$1:$E$8,3,1),"")

 

[Aladin Akyurek]

Is there a good reason for not using Advanced Filter?