Comparing Ranges and Returning Non-Common Items

Hi,

I have two tables of data – columns A and B in the attached file – and would like in column D to create a formula that compares columns A and B and then enters any non-common product names (e.g. Product F and Product M in my example) from D2 onwards.

Can someone please suggest a formula that will accomplish this.

Thanks!

See attached file. I've inserted a new column D and used C and D as helper columns (coloured blue - you could hide these if you wish), with formulae copied down beyond your data. Then the missing products are shown in column E.

Hope this helps.

Pete