Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

COMPARE VALUES BETWEEN TWO SHEETS

Hi,

I have a calc document contains two sheets, both sheets contain same columns: ID, DEPT, PRICE I need to compare the PRICE for each ID on both sheets. Example, for ID 001, DEPT A.01, the PRICE on sheet1 is 500. I want to compare it with it's PRICE on sheet2. If they are different, I need to mark it (maybe set the font to bold or the background color to red). There are nearly 26000 rows, so it will take too long to do it manually. Is there any way (a formula or something) that I can use to do it efficiently?

COMPARE VALUES BETWEEN TWO SHEETS

Hi,

I have a calc document contains two sheets, both sheets contain same columns: ID, DEPT, PRICE I need to compare the PRICE for each ID on both sheets. Example, for ID 001, DEPT A.01, the PRICE on sheet1 is 500. I want to compare it with it's PRICE on sheet2. If they are different, I need to mark it (maybe set the font to bold or the background color to red). There are nearly 26000 rows, so it will take too long to do it manually. Is there any way (a formula or something) that I can use to do it efficiently?