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.

	A	B	C	D	E	F	G
1	First Name	Last Name	Role	Start Up	----------	Unique	Unique
2	George	Aquino	Invested	Initech		George	Aquino
3	George	Aquino	Invested	Acme Corporation		Alban	Dushku
4	Alban	Dushku	Founded	Massive Dynamic		Femi	Folani
5	Alban	Dushku	Exited	Massive Dynamic
6	Femi	Folami	Invested	Soylent Corp
7	Femi	Folami	Invested	Soylent Corp

<tbody>
</tbody>

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.