Compare two columns

[OCM]

Greetings,

I’m trying to compare two columns and list what is in one, but not in the other list (sample attached).

My template has 25 rows, if nothing is entered in columns A & B, I would like my formula to return blank.


TIA

Regards,


OCM

 

[mintjulep]

This should help.

https://stackoverflow.com/questions...perations-union-intersection-minus-in-ms-exce

 

[OCM]

mintjulep,
Thank you for the resource link.
I applied the solution you provided and the formula worked nicely.

B - A (Only in B): =IF(NOT(IFNA(MATCH(B2,$A$2:$A$42,0),FALSE)),IF(B2,B2,""),"")

Regards,

OCM