# Formula to creating a List from a list of data

#### isaacghouston

##### New Member
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.

Last edited:

### Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"

#### ravishankar

##### Well-known Member
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

##### Board Regular
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),"")

##### MrExcel MVP
Is there a good reason for not using Advanced Filter?

Replies
3
Views
198
Replies
1
Views
114
Replies
13
Views
155
Replies
1
Views
182
Replies
0
Views
120

1,191,500
Messages
5,986,921
Members
440,065
Latest member
JCH136

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back