Pulling unique data from a list

[boll55]

I have a generated list that pulls data from a diffrent sheet. I need a formula to pull only unique values from that generated list since some values are list multipul times.

Thanks!


Excel Help Forum

 

[Akashwani]

Hi,

Does this work for you?...

Excel Workbook
	A	B	C	D
1	Product Code		Product Code
2	ID12345		ID12345
3	ID12346		ID12346
4	ID12347		ID12347
5	ID12348		ID12348
6	ID12349		ID12349
7	ID12350		ID12350
8	ID12351		ID12351
9	ID12352		ID12352
10	ID12353		ID12353
11	ID12345
12	ID12346
13	ID12350
14	ID12351
15	ID12348
16	ID12349
17	ID12350
18	ID12346
19	ID12352
20
Sheet8

The formula in C2 needs entering with ctrl shift enter NOT just enter, it can then be copied down.
You will obviously have to change the cell references to suit your layout.

I hope that helps.

Ak

 

[boll55]

yes, however, my data is in row a but needs to be placed in row h, not c is that possible?????

 

[Akashwani]

Hi,

Do you mean you have your data in COLUMN A and want the result in COLUMN H like this?....

Excel Workbook
	A	B	C	D	E	F	G	H	I
1	Product Code	*	*	*	*	*	*	Product Code	*
2	ID12345	*	*	*	*	*	*	ID12345	*
3	ID12346	*	*	*	*	*	*	ID12346	*
4	ID12347	*	*	*	*	*	*	ID12347	*
5	ID12348	*	*	*	*	*	*	ID12348	*
6	ID12349	*	*	*	*	*	*	ID12349	*
7	ID12350	*	*	*	*	*	*	ID12350	*
8	ID12351	*	*	*	*	*	*	ID12351	*
9	ID12352	*	*	*	*	*	*	ID12352	*
10	ID12353	*	*	*	*	*	*	ID12353	*
11	ID12345	*	*	*	*	*	*	*	*
12	ID12346	*	*	*	*	*	*	*	*
13	ID12350	*	*	*	*	*	*	*	*
14	ID12351	*	*	*	*	*	*	*	*
15	ID12348	*	*	*	*	*	*	*	*
16	ID12349	*	*	*	*	*	*	*	*
17	ID12350	*	*	*	*	*	*	*	*
18	ID12346	*	*	*	*	*	*	*	*
19	ID12352	*	*	*	*	*	*	*	*
20	*	*	*	*	*	*	*	*	*
Sheet8

Ak