Forum Discussion

sanjaydev's avatar
sanjaydev
Copper Contributor
Mar 10, 2024
Solved

compare two lists and extract the unique list

compare two lists and extract the unique list

 

excel
Formulas and Functions
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Mar 10, 2024

    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.

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor
    Mar 10, 2024

    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.

Resources