| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why did Excel create two identical worksheets? | Excel Discussion (Misc queries) | |||
| How do I match identical data from two different worksheets in one | New Users to Excel | |||
| COMPARE IDENTICAL DATA | New Users to Excel | |||
| Protection of identical cells on multiple worksheets | Excel Worksheet Functions | |||
| Format all worksheets for identical printing | Excel Discussion (Misc queries) | |||
Hybrid Mode
