Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
How to compare two work sheel cell by cell
10 views
Skip to first unread message
nkanaga
Oct 31, 2012, 12:27:02 PM10/31/12
to
Please some one help me on compare two work sheel cell by cell
--
nkanaga
zvkmpw
Nov 7, 2012, 9:11:44 PM11/7/12
to
> Please some one help me on compare two work sheet cell by cell
One way is to use a third sheet, put this in A1
=IF(EXACT(Sheet1!A1,Sheet2!A1),"y","n")
then copy A1 and paste it into the rest of the new sheet, as far as needed.
Since EXACT is case-sensitive, "this" is considered different from "This".
Don't be tempted into using the comparison Sheet1!A1=Sheet2!A1 because it considers 0 and FALSE and an empty cell to be all the same.
A different way is to use conditional formatting to color the cells of Sheet1 that are different from their Sheet2 conterparts. This way, there's no need for a third sheet. Look in Excel's built-in Help to read about conditional formatting.
One way is to use a third sheet, put this in A1
=IF(EXACT(Sheet1!A1,Sheet2!A1),"y","n")
then copy A1 and paste it into the rest of the new sheet, as far as needed.
Since EXACT is case-sensitive, "this" is considered different from "This".
Don't be tempted into using the comparison Sheet1!A1=Sheet2!A1 because it considers 0 and FALSE and an empty cell to be all the same.
A different way is to use conditional formatting to color the cells of Sheet1 that are different from their Sheet2 conterparts. This way, there's no need for a third sheet. Look in Excel's built-in Help to read about conditional formatting.
0 new messages