Sufiyan97
Well-known Member
- Joined
- Apr 12, 2019
- Messages
- 1,538
- Office Version
- 365
- 2013
- Platform
- Windows
I want to create a unique list of names from two different columns
A and B are source and expected result is in column D
A and B are source and expected result is in column D
Book6 | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
1 | List1 | List2 | Unique | ||||
2 | Dave | Dave | Dave | ||||
3 | Dave | Dave | Dwayne | ||||
4 | Dwayne | Dave | Joy | ||||
5 | Dwayne | Dwayne | Amy | ||||
6 | Dwayne | Joy | Ronny | ||||
7 | Dwayne | Joy | Cary | ||||
8 | Joy | Joy | |||||
9 | Joy | Joy | |||||
10 | Joy | Joy | |||||
11 | Amy | Ronny | |||||
12 | Amy | Cary | |||||
13 | Ronny | ||||||
14 | |||||||
15 | |||||||
Sheet1 |