Pull unique values when adjacent cells are "combined."

[brashandcrass]

Want to pull a list of names that are unique from A:B and have it appear in F:G as seen below.

[TABLE="width: 0"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]First Name[/TD]
[TD]Last Name[/TD]
[TD]Role[/TD]
[TD]Start Up[/TD]
[TD]----------[/TD]
[TD]Unique[/TD]
[TD]Unique[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]George[/TD]
[TD]Aquino[/TD]
[TD]Invested[/TD]
[TD]Initech[/TD]
[TD][/TD]
[TD]George[/TD]
[TD]Aquino[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]George[/TD]
[TD]Aquino[/TD]
[TD]Invested[/TD]
[TD]Acme Corporation[/TD]
[TD][/TD]
[TD]Alban[/TD]
[TD]Dushku[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]Alban[/TD]
[TD]Dushku[/TD]
[TD]Founded[/TD]
[TD]Massive Dynamic[/TD]
[TD][/TD]
[TD]Femi[/TD]
[TD]Folani[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]Alban[/TD]
[TD]Dushku[/TD]
[TD]Exited[/TD]
[TD]Massive Dynamic[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]Femi[/TD]
[TD]Folami[/TD]
[TD]Invested[/TD]
[TD]Soylent Corp[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]Femi[/TD]
[TD]Folami[/TD]
[TD]Invested[/TD]
[TD]Soylent Corp[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Thanks!

 

[Aladin Akyurek]

Aladin Akyurek, undoubtedly this approach is way over my head. I appreciate the input and your time but this is unfortunately one of those occasions I cannot sacrifice time to learn how to use Formulas | Name Manager.

Thanks for the comment. But there is nothing much or special about Formulas | Name Manager. The time you need to follow the instructions will sure be shorter than the time I needed to type them out for you.

By the way, the COUNTIF formula should be less efficient and difficult to adapt to more conditions.

 

[brashandcrass]

NM... it didn't work ¯\_(ツ)_/¯

I'll be back if I hit a wall.