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

  • Thread starter Thread starter sdg105
  • Start date Start date
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?
 
assuming the values are in, say, A2 - A100 of each sheet...

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

and copy down
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Comparing two columns 1
Need to merge worksheets - Excel 2003 0
Compare and merge worksheets 2
Comparing Two Spreadsheets 5
Compare difference between 2 worksheets 2003 1
how do I compare versions of an Excel worksheet 3
Compare 2 worksheets 1
Compare two worksheets - macro help 2

Back
Top