How to match data between 2 different sheets

  • Thread starter Thread starter Saed
  • Start date Start date
S

Saed

Dear All,

Kindly I have data in sheet 1 & data in sheet 2, I need the data which is
not matching to be transfer to sheet 3.
 
Hi Saed
Is this what your looking for?
=IF(Sheet1!A1<>Sheet2!A1,Sheet1!A1)
Regards
Cimjet
 
Hi Cimjet,

Thanks for your respond, actually I think I didnt explain wel that is the
reason, your reply didnt help me.

I have a large data in excel file Sheet 1, and some updation on Sheet 2 on
the same excel file. Now I want to check which are missing data in sheet 2,
so I am looking some formula or macro to copy missing data in Sheet 3, then I
can easily update the data accordingly.

Thanks & Regards

Saed
 
Back
Top