How do I compare two worksheets to see if they're identical?

S

sdg105

I have entered multiple choice answers from several surveys into a worksheet
for a research project. I was asked to enter the data a second time so the
data could be compared to make sure there were no data entry errors. I have
done this, but now I need help on how to compare the two worksheets to make
sure the data is the same.

What function do I need to use to do this?
 
S

Sean Timmons

assuming the values are in, say, A2 - A100 of each sheet...

=if(sheet1!A2=sheet2!A2,"","Error")

and copy down
 
B

Barb Reinhardt

Do a search for a Compare.xla add-in. I'm not sure where I got mine, but
it's quite helpful.
--
HTH,
Barb Reinhardt

If this post was helpful to you, please click YES below.
 
P

Peo Sjoblom

!$###??!

Damn spellchecker

That should be Stephen Bullen's

--


Regards,


Peo Sjoblom
 
Top