Comparing two Excel spreadsheets to highlight changes
I need to compare two large, multi page spreadsheets and combine them into one spreadsheet showing the data that was in the original one and also what it was changed to in the second one?
I have Excel 2016 on PC and Office 365 Premium on Mac if that helps. It seems to be only older versions of Excel that have that function.
Please can you help #demandingboss
spreadsheet microsoft-excel-2016 file-compare
asked Sep 12 '16 at 12:21
Peter BeechPeter Beech
611
add a comment |
I need to compare two large, multi page spreadsheets and combine them into one spreadsheet showing the data that was in the original one and also what it was changed to in the second one?
I have Excel 2016 on PC and Office 365 Premium on Mac if that helps. It seems to be only older versions of Excel that have that function.
Please can you help #demandingboss
spreadsheet microsoft-excel-2016 file-compare
asked Sep 12 '16 at 12:21
Peter BeechPeter Beech
611
Welcome to Super User! Please note that Super User is not a free script/code writing service. If you tell us what you have tried so far (include the scripts/code you are already using) and where you are stuck then we can try to help with specific problems. You should also read How do I ask a good question?.
– DavidPostill♦
Sep 12 '16 at 12:40
add a comment |
I need to compare two large, multi page spreadsheets and combine them into one spreadsheet showing the data that was in the original one and also what it was changed to in the second one?
I have Excel 2016 on PC and Office 365 Premium on Mac if that helps. It seems to be only older versions of Excel that have that function.
Please can you help #demandingboss
spreadsheet microsoft-excel-2016 file-compare
asked Sep 12 '16 at 12:21
Peter BeechPeter Beech
611
I need to compare two large, multi page spreadsheets and combine them into one spreadsheet showing the data that was in the original one and also what it was changed to in the second one?
I have Excel 2016 on PC and Office 365 Premium on Mac if that helps. It seems to be only older versions of Excel that have that function.
Please can you help #demandingboss
spreadsheet microsoft-excel-2016 file-compare
spreadsheet microsoft-excel-2016 file-compare
asked Sep 12 '16 at 12:21
Peter BeechPeter Beech
611
asked Sep 12 '16 at 12:21
Peter BeechPeter Beech
611
asked Sep 12 '16 at 12:21
Peter BeechPeter Beech
611
asked Sep 12 '16 at 12:21
Peter BeechPeter Beech
611
asked Sep 12 '16 at 12:21
Peter BeechPeter Beech
611
611
Welcome to Super User! Please note that Super User is not a free script/code writing service. If you tell us what you have tried so far (include the scripts/code you are already using) and where you are stuck then we can try to help with specific problems. You should also read How do I ask a good question?.
– DavidPostill♦
Sep 12 '16 at 12:40
add a comment |
Welcome to Super User! Please note that Super User is not a free script/code writing service. If you tell us what you have tried so far (include the scripts/code you are already using) and where you are stuck then we can try to help with specific problems. You should also read How do I ask a good question?.
– DavidPostill♦
Sep 12 '16 at 12:40
Welcome to Super User! Please note that Super User is not a free script/code writing service. If you tell us what you have tried so far (include the scripts/code you are already using) and where you are stuck then we can try to help with specific problems. You should also read How do I ask a good question?.
– DavidPostill♦
Sep 12 '16 at 12:40
Welcome to Super User! Please note that Super User is not a free script/code writing service. If you tell us what you have tried so far (include the scripts/code you are already using) and where you are stuck then we can try to help with specific problems. You should also read How do I ask a good question?.
– DavidPostill♦
Sep 12 '16 at 12:40
add a comment |
1 Answer
1
active
oldest
votes
It is the simplest way to compare data in Excel that lets you identify cells with different values. As the result, you will have a difference report in a new worksheet.
To compare two Excel worksheets for differences, just open a new empty sheet, enter the following formula in cell A1, and then copy it down and to the right:
=IF(Sheet1!A1<> Sheet2!A1, "Sheet1:"&Sheet1!A1&" vs Sheet2:"&Sheet2!A1, "")
There are other methods of creating rules which can check for certain conditions (does cell on sheet 1 match same cell on sheet 2 etc..), you can find more information here: https://www.ablebits.com/office-addins-blog/2016/02/25/compare-two-excel-files-sheets/
answered Sep 12 '16 at 12:58
user2924019user2924019
175316
add a comment |
protected by Community♦ Jan 16 at 10:07
Thank you for your interest in this question.
Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).
Would you like to answer one of these unanswered questions instead?
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
It is the simplest way to compare data in Excel that lets you identify cells with different values. As the result, you will have a difference report in a new worksheet.
To compare two Excel worksheets for differences, just open a new empty sheet, enter the following formula in cell A1, and then copy it down and to the right:
=IF(Sheet1!A1<> Sheet2!A1, "Sheet1:"&Sheet1!A1&" vs Sheet2:"&Sheet2!A1, "")
There are other methods of creating rules which can check for certain conditions (does cell on sheet 1 match same cell on sheet 2 etc..), you can find more information here: https://www.ablebits.com/office-addins-blog/2016/02/25/compare-two-excel-files-sheets/
answered Sep 12 '16 at 12:58
user2924019user2924019
175316
add a comment |
It is the simplest way to compare data in Excel that lets you identify cells with different values. As the result, you will have a difference report in a new worksheet.
To compare two Excel worksheets for differences, just open a new empty sheet, enter the following formula in cell A1, and then copy it down and to the right:
=IF(Sheet1!A1<> Sheet2!A1, "Sheet1:"&Sheet1!A1&" vs Sheet2:"&Sheet2!A1, "")
There are other methods of creating rules which can check for certain conditions (does cell on sheet 1 match same cell on sheet 2 etc..), you can find more information here: https://www.ablebits.com/office-addins-blog/2016/02/25/compare-two-excel-files-sheets/
answered Sep 12 '16 at 12:58
user2924019user2924019
175316
add a comment |
It is the simplest way to compare data in Excel that lets you identify cells with different values. As the result, you will have a difference report in a new worksheet.
To compare two Excel worksheets for differences, just open a new empty sheet, enter the following formula in cell A1, and then copy it down and to the right:
=IF(Sheet1!A1<> Sheet2!A1, "Sheet1:"&Sheet1!A1&" vs Sheet2:"&Sheet2!A1, "")
There are other methods of creating rules which can check for certain conditions (does cell on sheet 1 match same cell on sheet 2 etc..), you can find more information here: https://www.ablebits.com/office-addins-blog/2016/02/25/compare-two-excel-files-sheets/
answered Sep 12 '16 at 12:58
user2924019user2924019
175316
It is the simplest way to compare data in Excel that lets you identify cells with different values. As the result, you will have a difference report in a new worksheet.
To compare two Excel worksheets for differences, just open a new empty sheet, enter the following formula in cell A1, and then copy it down and to the right:
=IF(Sheet1!A1<> Sheet2!A1, "Sheet1:"&Sheet1!A1&" vs Sheet2:"&Sheet2!A1, "")
There are other methods of creating rules which can check for certain conditions (does cell on sheet 1 match same cell on sheet 2 etc..), you can find more information here: https://www.ablebits.com/office-addins-blog/2016/02/25/compare-two-excel-files-sheets/
answered Sep 12 '16 at 12:58
user2924019user2924019
175316
answered Sep 12 '16 at 12:58
user2924019user2924019
175316
answered Sep 12 '16 at 12:58
user2924019user2924019
175316
answered Sep 12 '16 at 12:58
user2924019user2924019
175316
175316
add a comment |
add a comment |
protected by Community♦ Jan 16 at 10:07
Thank you for your interest in this question.
Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).
Would you like to answer one of these unanswered questions instead?
Welcome to Super User! Please note that Super User is not a free script/code writing service. If you tell us what you have tried so far (include the scripts/code you are already using) and where you are stuck then we can try to help with specific problems. You should also read How do I ask a good question?.
– DavidPostill♦
Sep 12 '16 at 12:40