How to combine 2 columns into 1 column and remove the duplicate?

[maytps]

Need experts help..

I am trying to remove the duplicates from 3 different columns and combine the unique values into one column by using an Excel formula..

Test.JPG


(Order is not important)

Thanks much!!

[:) Sixthsense :)]

	A	B	C	D	E
1	A	B	C		Result
2	1	2	2		1
3	5	5	7		2
4	8	8	8		4
5	9	4	9		5
6	7	6			6
7	10				7
8					8
9					9
10					10
11					---End---
12
13
14

	E
1	Result
2	=IF(COUNTIF($E$1:E1,"---End---"),"",IFERROR(SMALL($A$2:$C$7,COUNTIF($A$2:$C$7,"<="&IF(ROW()=2,0,E1))+1),"---End---"))
3	=IF(COUNTIF($E$1:E2,"---End---"),"",IFERROR(SMALL($A$2:$C$7,COUNTIF($A$2:$C$7,"<="&IF(ROW()=2,0,E2))+1),"---End---"))
4	=IF(COUNTIF($E$1:E3,"---End---"),"",IFERROR(SMALL($A$2:$C$7,COUNTIF($A$2:$C$7,"<="&IF(ROW()=2,0,E3))+1),"---End---"))
5	=IF(COUNTIF($E$1:E4,"---End---"),"",IFERROR(SMALL($A$2:$C$7,COUNTIF($A$2:$C$7,"<="&IF(ROW()=2,0,E4))+1),"---End---"))
6	=IF(COUNTIF($E$1:E5,"---End---"),"",IFERROR(SMALL($A$2:$C$7,COUNTIF($A$2:$C$7,"<="&IF(ROW()=2,0,E5))+1),"---End---"))
7	=IF(COUNTIF($E$1:E6,"---End---"),"",IFERROR(SMALL($A$2:$C$7,COUNTIF($A$2:$C$7,"<="&IF(ROW()=2,0,E6))+1),"---End---"))
8	=IF(COUNTIF($E$1:E7,"---End---"),"",IFERROR(SMALL($A$2:$C$7,COUNTIF($A$2:$C$7,"<="&IF(ROW()=2,0,E7))+1),"---End---"))
9	=IF(COUNTIF($E$1:E8,"---End---"),"",IFERROR(SMALL($A$2:$C$7,COUNTIF($A$2:$C$7,"<="&IF(ROW()=2,0,E8))+1),"---End---"))
10	=IF(COUNTIF($E$1:E9,"---End---"),"",IFERROR(SMALL($A$2:$C$7,COUNTIF($A$2:$C$7,"<="&IF(ROW()=2,0,E9))+1),"---End---"))
11	=IF(COUNTIF($E$1:E10,"---End---"),"",IFERROR(SMALL($A$2:$C$7,COUNTIF($A$2:$C$7,"<="&IF(ROW()=2,0,E10))+1),"---End---"))
12	=IF(COUNTIF($E$1:E11,"---End---"),"",IFERROR(SMALL($A$2:$C$7,COUNTIF($A$2:$C$7,"<="&IF(ROW()=2,0,E11))+1),"---End---"))
13	=IF(COUNTIF($E$1:E12,"---End---"),"",IFERROR(SMALL($A$2:$C$7,COUNTIF($A$2:$C$7,"<="&IF(ROW()=2,0,E12))+1),"---End---"))