Forum Discussion
Solved
compare two lists and extract the unique list
compare two lists and extract the unique list
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.
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.