compare 2 columns and create new column with missing values in second column

Hello,

I'm trying to write a macto to search all values from column A of sheet1 in column A of sheet2 and create a new list in sheet3 of all the values from sheet 1 which are not found in sheet2

thanks in advance

Hi Jroelan,

Welcome in Excel Forum.

I have prepared a small macro which may help you. I have preapared this in a single sheet. However, you can modify this to show the result in sheet3 keeping data in sheet1 and 2. Hope it will guide you. The same can be done by macro only, but I thought it will help you in future if you try it yourself. Let us know. We certainly help if require.

Sorry friend,

Earlier I have attached file with wrong formula. However, the formula also help to find the duplicate record.

Thanks,
Now I have somthing to start fomm