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

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?

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

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

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

and copy down

"sdg105" wrote:

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?

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

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.



"Sean Timmons" wrote:

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

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

and copy down

"sdg105" wrote:

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?

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

It's on Chip's web page

http://www.cpearson.com/excel/Download.htm


Probably from Stephen Bullpen's site as well

--


Regards,


Peo Sjoblom

"Barb Reinhardt" wrote in message
...
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.



"Sean Timmons" wrote:

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

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

and copy down

"sdg105" wrote:

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?

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

!$###??!

Damn spellchecker

That should be Stephen Bullen's

--


Regards,


Peo Sjoblom

"Peo Sjoblom" wrote in message
...
It's on Chip's web page

http://www.cpearson.com/excel/Download.htm


Probably from Stephen Bullpen's site as well

--


Regards,


Peo Sjoblom

"Barb Reinhardt" wrote in
message ...
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.



"Sean Timmons" wrote:

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

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

and copy down

"sdg105" wrote:

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?

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

You must be thinking about baseball. :)

Barb Reinhardt


"Peo Sjoblom" wrote:

It's on Chip's web page

http://www.cpearson.com/excel/Download.htm


Probably from Stephen Bullpen's site as well

--


Regards,


Peo Sjoblom

"Barb Reinhardt" wrote in message
...
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.



"Sean Timmons" wrote:

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

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

and copy down

"sdg105" wrote:

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?