Exclude or filter values missing in the other column with except in Excel

• 1 Get values from col A missing in B:
  =IF(ISERROR(MATCH($A$2:$A$150,$B$2:$B$370,0)),A2,"")
  
• 2 Get values from col B missing in A:
  =IF(ISERROR(MATCH($B$2:$B$370,$A$2:$A$150,0)),B2,"")
  
• N Drag the formula from C2 or D2 all the way down. First row contains headers.
  

References

• https://stackoverflow.com/questions/5768129/comparing-two-columns-in-excel-with-exclusion