listed values without duplicate

[abdulla88]

I have dropdown list in column A . How can the values in column A appear and listed in column B ( without duplication )?
as below>>

test.xlsx
	A	B
1	WARD	LIST
2	103
3	105
4	105
5	106
6	109
7	102
8	103
9	103
10
Sheet2

Cells with Data Validation
Cell	Allow	Criteria
A2:A10	List	101, 102, 103, 104, 105, 106, 107, 108, 109,

 

[Peter_SSs]

Is this what you mean?

21 04 02.xlsm
	A	B
1	WARD	LIST
2	103	103
3	105	105
4	105	106
5	106	109
6	109	102
7	102
8	103
9	103
10
List

Cell Formulas
Range	Formula
B2:B10	B2	=IFERROR(INDEX($A$2:$A$10,MATCH(0,INDEX(COUNTIF($B$1:B1,$A$2:$A$10)+(A$2:A$10=""),0),0)),"")

 

[abdulla88]

Is this what you mean?

21 04 02.xlsm
	A	B
1	WARD	LIST
2	103	103
3	105	105
4	105	106
5	106	109
6	109	102
7	102
8	103
9	103
10
List

Cell Formulas
Range	Formula
B2:B10	B2	=IFERROR(INDEX($A$2:$A$10,MATCH(0,INDEX(COUNTIF($B$1:B1,$A$2:$A$10)+(A$2:A$10=""),0),0)),"")

exactly that's what I mean

Thanks alot

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.