-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
Comparing two versions of the same worksheet
- Thread starter tlingit
- Start date
Excel Facts
Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.
one idea is to put the two sheets next to each other in the same workbook (renaming one of them). For example, if one is named "MyVersion" and the other "ClientVersion" then add a new sheet, and in the new sheet's cell A1, put:
if(MyVersion!A1<>ClientVersion!A1,"***","")
then "***" will show up if they're different.
if(MyVersion!A1<>ClientVersion!A1,"***","")
then "***" will show up if they're different.
Upvote
0
Similar threads
- Replies
- 2
- Views
- 291
- Question
- Replies
- 2
- Views
- 82
- Solved
- Replies
- 4
- Views
- 539
- Replies
- 4
- Views
- 276
