combine two columns removing duplicates

[priyanka patil]

I have these 2 coulmn:

Column 1 Column 2
A E
B F
C A
D C
G

I need to compare the two columns so the output must be:

Column 3
A
B
C
D
E
F
G

 

[Belleke]

Welcome on Chandoo
Something like this?
See attached

 

[pecoflyer]

Have a look at https://www.extendoffice.com/docume...t-unique-values-from-multiple-columns.html#a1

 

[bosco_yip]

Another formula solution

In C2, copied down :

=IF(ROW(A1)<=COUNTA(A$2:A$10),INDEX(A$2:A$10,ROW(A1)),INDEX(B$2:B$10,MATCH(0,INDEX(COUNTIF(C$1:C1,B$2:B$10),0),0))&"")

Regards
Bosco

 

[priyanka patil]

Welcome on Chandoo
Something like this?
See attached

Actually macro file is disabled.

 

[Belleke]

Macrofile is not disabled, my example works., click in A2 and push the button.

 

[pecoflyer]

What's wrong with the formula solutions proposed?

 

[anaand01]

The code is perfectly working, but unable to view the code!
any help

 

[Belleke]

Euh?
Alt + F11

 

[priyanka patil]

View attachment 54412

Another formula solution

In C2, copied down :

=IF(ROW(A1)<=COUNTA(A$2:A$10),INDEX(A$2:A$10,ROW(A1)),INDEX(B$2:B$10,MATCH(0,INDEX(COUNTIF(C$1:C1,B$2:B$10),0),0))&"")

Regards
Bosco

Thank u for your prompt reply.
I am unable to get logic of formula. Kindly explain me.

 

[pecoflyer]

Have you tried the "Evaluate formula" tool to see how the formula works?

 

[CMLET]

View attachment 54412

Another formula solution

In C2, copied down :

=IF(ROW(A1)<=COUNTA(A$2:A$10),INDEX(A$2:A$10,ROW(A1)),INDEX(B$2:B$10,MATCH(0,INDEX(COUNTIF(C$1:C1,B$2:B$10),0),0))&"")

Regards
Bosco

Awesome Formula!