5 Replies Latest reply: Feb 13, 2012 4:16 AM by Alan Hendrickx RSS

    Compare 2 columns & display unique values

    Alan Hendrickx

      Hi,

       

      I have a file with 2 non-identical columns: A & B. Each entry in Column A has an entry somewhere in Column B. I want to display a list of entries that will compare all the entries in A with those in B and only display those that are missing from B.

       

      In Excel this works:

      =IF(COUNTIF(B:B,A2)=0,A2,"")

       

      I have attached a sheet containing some dummy data and  the excel formula working correctly.

       

      Any help would be greatly appreciated...

       

      Thanks

      A