decadence
Well-known Member
- Joined
- Oct 9, 2015
- Messages
- 525
- Office Version
- 365
- 2016
- 2013
- 2010
- 2007
- Platform
- Windows
Hi, I would like to compare 2 columns by a 3rd Column and return the values to show what the unique differences are between the 2 columns, but by returning the values found in 2 more columns adjacently but on the same row if Found in the 2 columns. Also the data varies in Rows, Essentially I want to compare the 2 columns to find what is different between the lists, Can someone help please
Example
Example
Master List | List 1 | List 2 | Found in List 1 | Found In List 2 |
abc | def | def | ||
123 | abc | 123 | abc | |
def | 123 | jkl | jkl | |
ghi | 789 | 789 | ||
456 | ghi | ghi | ||
789 | 456 | 456 | ||
jkl |