Sheets comparing

[Saed]

Salam

I have 2 different sheets in 1 excel work book with different columns but
with same data, so i need to copmare the data in sheet 1 with the data in
sheet 2 & different dat to be transfered to sheet 3.

 

[OssieMac]

Can I assume that when you say same data but different columns that you mean
that both are set out the same way but some with different values?.

If above is a correct assumption then on the third sheet you could insert a
formula something like this:-

=IF(Sheet1!A1=Sheet2!D1,"",Sheet1!A1)

It compares cell A1 on sheet 1 to cell D1 on sheet 2 and if the same inserts
"" (which is zero length string) and if not the same then inserts value of A1
on sheet1.

You can copy or drag the formula across a range that is equivalent to the
range on sheets 1 and 2.