Compare the values of two worksheets
Closed
tkp123
-
Jun 7, 2016 at 06:01 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jun 13, 2016 at 11:24 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jun 13, 2016 at 11:24 AM
Related:
- Compare the values of two worksheets
- Beyond compare - Download - File management
- Excel compare two sheets - Guide
- Based on the values in cells b77 ✓ - Excel Forum
- Which function is used to compare a cell value to an array of cells and return a value that matches the location of the value in the array, and is used when there are more than two columns in the array ✓ - Excel Forum
- Insert a new sheet at the end of the tab names and paste the range names starting in cell a1. autofit columns a:b and name the worksheet as range names. ✓ - Excel Forum
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Jun 13, 2016 at 11:24 AM
Jun 13, 2016 at 11:24 AM
Hi tkp123,
Could you give a small example of your data on all 3 sheets for better understanding.
Like this:
Sheet1
abc 3
def 5
Sheet 2
jkl 9
def 4
Sheet 3
abc 3
def 9 'added both sheets because of match
def 4
Best regards,
Trowa
Could you give a small example of your data on all 3 sheets for better understanding.
Like this:
Sheet1
abc 3
def 5
Sheet 2
jkl 9
def 4
Sheet 3
abc 3
def 9 'added both sheets because of match
def 4
Best regards,
Trowa