Compare 2 lists in Excel

Not related to DB or Tsql...but useful for every DBA



Compare 2 lists in Excel

To find A2 is missing in Column B
=IF(ISERROR(NOT(MATCH(A2,$B$1:$B$7494,0))),A2,"")


To find B2 is missing in Column A
=IF(ISERROR(NOT(MATCH(B2,$A$1:$A$7291,0))),B2,"")