Comparing 2 worksheets-HELP

[kleubner]

Hi, I have entered identical data (hopefully) into two separate
worksheets and now want to use a 3rd worksheet to tell me if all cells
between the two worksheets are identical. The formula that my advisor
gave me isn't working and I think I might have written it down
incorrectly. The formula is as follows:
sheet3=if(Sheet1!B2=Sheet2!B2,"",!!!") using Excel2002

I also need to know how to apply this formula to all cells in worksheet
3 but with changing comparisons. Help! I am trying to compare data and
then run statistical analyses in SPSS, but this is the first step and I
cannot go beyond until I figure this out.

 

[Anders S]

Hi,

In sheet3, enter in cell A2 (or any cell):

=IF(Sheet2!B2=Sheet3!B2,"","!!!")

Then fill down, that is drag the little black square in the bottom right corner of A2 down as far as needed. The cell references will adjust automatically.

HTH
Anders Silvén

 

[kleubner]

Thank you so much! I am now able to complete the analyses for my
advisor. You are my blessing today! ~~Krista