Creating a List From the Unique Data of Two Separate Rows.

[LearningExcel0]

I am attempting to create a list from the unique data of 2 row. I have tried VLOOKUP, MATCH, and PivotTables and couldn't find what I'm looking for, I am still new to Excel and its various functions.

An example of what I'm trying to accomplish is:
In A1 to A5 we have: a,b,c,d,e and in B1 to B5 we have: a,b,c,f,g

I want row C to show e,d as a list and row D to show f,g as a list.

As row C removes the duplicates between rows A and B and as a list keeps the unique values of row A, while row D removes the duplicates between rows A and B and as a list keeps the unique values of row B.

If anyone could help me out with a formula or a direction of which formula or functions I could use it would be greatly appreciated.

 

[My Aswer Is This]

There is no such thing as Row C
Your quote:"I want row C to show e,d as a list and row D to show f,g as a list."

In Excel we have Columns A,B,C,D etc. etc.
And we have Rows 1,2,3,4 etc. etc.

 

[Aladin Akyurek]

[Table="width:, class:grid"][tr][td]Row\Col[/td][td]

A​

[/td][td]

B​

[/td][td]

C​

[/td][td]

D​

[/td][/tr]
[tr][td]

1​

[/td][td]a[/td][td]a[/td][td]d[/td][td]f[/td][/tr]


[tr][td]

2​

[/td][td]b[/td][td]b[/td][td]e[/td][td]g[/td][/tr]


[tr][td]

3​

[/td][td]c[/td][td]c[/td][td][/td][td][/td][/tr]


[tr][td]

4​

[/td][td]d[/td][td]f[/td][td][/td][td][/td][/tr]


[tr][td]

5​

[/td][td]e[/td][td]g[/td][td][/td][td][/td][/tr]
[/table]

In C2 control+shift+enter, not just enter, and copy down:

=IFERROR(INDEX($A$1:$A$5,SMALL(IF(1-ISNUMBER(MATCH($A$1:$A$5,$B$1:$B$5,0)),
  ROW($A$1:$A$5)-ROW($A$1)+1),ROWS($C$2:C2))),"")

In D2 control+shift+enter, not just enter, and copy down:

=IFERROR(INDEX($B$1:$B$5,SMALL(IF(1-ISNUMBER(MATCH($B$1:$B$5,$A$1:$A$5,0)),
  ROW($B$1:$B$5)-ROW($B$1)+1),ROWS($D$2:D2))),"")

<strike></strike><strike></strike>

 

[LearningExcel0]

Thank you. Corrected it should say:

An example of what I'm trying to accomplish is:
In A1 to A5 we have: a,b,c,d,e and in B1 to B5 we have: a,b,c,f,g

I want column C to show e,d as a list and column D to show f,g as a list.

As column C removes the duplicates between columns A and B and as a list keeps the unique values of column A, while column D removes the duplicates between columns A and B and as a list keeps the unique values of columns B.

Is there a way to edit my original document? This is my first post, Thank you.

 

[LearningExcel0]

That is exactly what I was looking for! Thank you very much!

 

[Aladin Akyurek]

That is exactly what I was looking for! Thank you very much!

You are welcome.