A
adwikcool
Guest
Hi,
I want to compare 2 excel sheet and save the results(differences) to the another file.
Sheet 1
A B C D E
aa bb cc dd ee
1 2 4 5 7
1 3 5 6 8
Sheet 2
E B A C D
ee bb aa cc dd
7 4 1 4 5
8 3 1 55 6
As i have select 2 headings on each sheets. You can say make this heading primarily and then search.
As i have to compare in the way that A and aa from 1st sheet and then find the same 2 values(A and aa) from the another sheet.
if found then compare the values from both sheets.
and give the result(differences on the sheet).
Like on Sheet1, i select B and bb column, then i search on sheet2, if i found then i start comparing the value. According to screenshot. AS sheet1 has 2 and 3 and sheet2 has 4 and 3. here 2 and 4 are different so give the headings of the difference value and then both values.
like in RESULT
B bb 2(Sheet1) 4(Sheet2)
And so one.
Please help on this. i am really thankful to you for your help.
Continue reading...
I want to compare 2 excel sheet and save the results(differences) to the another file.
Sheet 1
A B C D E
aa bb cc dd ee
1 2 4 5 7
1 3 5 6 8
Sheet 2
E B A C D
ee bb aa cc dd
7 4 1 4 5
8 3 1 55 6
As i have select 2 headings on each sheets. You can say make this heading primarily and then search.
As i have to compare in the way that A and aa from 1st sheet and then find the same 2 values(A and aa) from the another sheet.
if found then compare the values from both sheets.
and give the result(differences on the sheet).
Like on Sheet1, i select B and bb column, then i search on sheet2, if i found then i start comparing the value. According to screenshot. AS sheet1 has 2 and 3 and sheet2 has 4 and 3. here 2 and 4 are different so give the headings of the difference value and then both values.
like in RESULT
B bb 2(Sheet1) 4(Sheet2)
And so one.
Please help on this. i am really thankful to you for your help.
Continue reading...