Finding the delta between two lists

[excelos]

Hello

I have two lists and I want to put each next to the other so that the values from one list that do not appear in the second list, have a blank value in the second list and vice versa.

E.g.

List1
1
2
3

List2
1
4
3

Result:
1, 1
2, NULL
NULL, 4
3, 3

I can do that with PowerBI by building a data model and putting the two lists one next to the other.

Is it possible to do that with Excel?

Thanks

 

[Saurabhj]

Yes, using VBA we can do this.