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

    Compare 2 columns & display unique values



      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:



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


      Any help would be greatly appreciated...