compare two lists and extract the unique list

[sanjaydev]

compare two lists and extract the unique list

[#2 · Accepted solution]

@sanjaydev Provided you are using Excel365 you could use this:

=UNIQUE(VSTACK(NewList,OldList),,TRUE)

NewList and OldList refer to the relevant ranges of the two lists. That is, A2:G14 and I2:O14.