Comparision of Excel sheets
Closed
pws
-
May 30, 2012 at 02:47 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Feb 10, 2014 at 11:15 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Feb 10, 2014 at 11:15 AM
Related:
- Comparision of Excel sheets
- Mark sheet in excel - Guide
- Sheets right to left - Guide
- How to open excel sheet in notepad++ - Guide
- How to take screenshot of excel sheet on laptop - Guide
- Excel mod apk for pc - Download - Spreadsheets
3 responses
Mehedad
Posts
22
Registration date
Thursday April 19, 2012
Status
Member
Last seen
April 16, 2013
3
May 30, 2012 at 05:18 AM
May 30, 2012 at 05:18 AM
A sample data would have been useful which would have showed what values are being compared. However, assuming that you need to copy a single Cell in Sheet 1 if the data is not matching, it can be done using formula:
=IF(A2=Sheet2!A2,"Match",Sheet2!A1)
Little more details would have been helpful. Let me know if it worked.
=IF(A2=Sheet2!A2,"Match",Sheet2!A1)
Little more details would have been helpful. Let me know if it worked.
Hi,
I am looking for copying row values to sheet3 if the fileds in sheet1(coloumn A) is matching with filed in sheet2(coloumn A).But i need only difference values.
Lets take a look below:
Sheet1 contains :
columnA ColumnB
ABC 10
XYZ 20
LKJ 30
Sheet2 contains :
columnA ColumnB
XYZ 20
ABC 50
LKJ 30
Now i need in sheet 3 like below:
columnA ColumnB
ABC 10
ABC 50
Because ABC having different values in sheet1 and sheet2.
Please provide me a macro code so that we will get reports based on fileds to compare.
I am looking for copying row values to sheet3 if the fileds in sheet1(coloumn A) is matching with filed in sheet2(coloumn A).But i need only difference values.
Lets take a look below:
Sheet1 contains :
columnA ColumnB
ABC 10
XYZ 20
LKJ 30
Sheet2 contains :
columnA ColumnB
XYZ 20
ABC 50
LKJ 30
Now i need in sheet 3 like below:
columnA ColumnB
ABC 10
ABC 50
Because ABC having different values in sheet1 and sheet2.
Please provide me a macro code so that we will get reports based on fileds to compare.
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Jun 11, 2012 at 10:22 AM
Jun 11, 2012 at 10:22 AM
Hi pws,
Start by copying both columns of both sheets to the 3rd sheet and sort them alphabetically.
Data looks like:
Column C is used for formula:
Cell C2: =IF(A1&B1=A2&B2,1,0)+IF(A2&B2=A3&B3,1,0)
Drag formula down.
Filter data on "bigger then 0" and delete the visible rows.
You can then remove the filter and delete column C.
Best regards,
Trowa
Start by copying both columns of both sheets to the 3rd sheet and sort them alphabetically.
Data looks like:
ColA ColB Header Header ABC 10 ABC 50 LKJ 30 LKJ 30 XYZ 20 XYZ 20
Column C is used for formula:
Cell C2: =IF(A1&B1=A2&B2,1,0)+IF(A2&B2=A3&B3,1,0)
Drag formula down.
Filter data on "bigger then 0" and delete the visible rows.
You can then remove the filter and delete column C.
Best regards,
Trowa
Feb 10, 2014 at 05:05 AM
It WORKED..
But I need COMMENTS that are in a Cell also as a PART OF PARAMETER
for comparison.In other words "EXACT MATCH" .of cell to cell
Please help me I am comparing 7 years data comments in a cell ( that was lost) just recovered with adhoc data (without Comments
Please help me
regards
ansharma
Feb 10, 2014 at 11:15 AM
Could you provide a little sample of your data how it is and how you foresee it.
Best regards,
Trowa