Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sheets comparing
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sheets comparing
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. -- Regards, OssieMac "Saed" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Comparing Two Sheets | Excel Worksheet Functions | |||
Comparing Across Sheets | Excel Discussion (Misc queries) | |||
comparing 2 sheets | Excel Discussion (Misc queries) | |||
Comparing columns in sheets | Excel Discussion (Misc queries) | |||
comparing 2 sheets | Excel Worksheet Functions |