eemoon
asked on
How to find the difference between two excel table ?
Hi Any expert can tell how to find the difference between two excel table ? Thank you
Can you post the workbook and tell us how you want the difference reported?
ASKER
thanks for your fast reply
it looks like the below tow tables
1 3 8 11
1 6 9 12
1 3 8 11
1 6 5 12
Above is two table, which has 4 column and 2 row, respectively. the difference between two table is 9 in up table and 5 in down table.
The real table is very large. How to find the difference in the two large table ?
it looks like the below tow tables
1 3 8 11
1 6 9 12
1 3 8 11
1 6 5 12
Above is two table, which has 4 column and 2 row, respectively. the difference between two table is 9 in up table and 5 in down table.
The real table is very large. How to find the difference in the two large table ?
Please explain why "the difference between two table is 9 in up table and 5 in down table".
When you say "The real table is very large" do you mean that there are more rows? More columns?
When you say "The real table is very large" do you mean that there are more rows? More columns?
ASKER
When you say "The real table is very large" do you mean that there are more rows? More columns?Yes
Please explain why "the difference between two table is 9 in up table and 5 in down table".this is explanation for that above table example
1 3 8 11
1 6 9 12
1 3 8 11
1 6 5 12
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you. If I just want to compare two column( or two row) difference, do you think there is simpler way to do that ?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You're welcome and I'm glad I was able to help.
In my profile you'll find links to some articles I've written that may interest you.
Marty - MVP 2009 to 2015, Experts-Exchange Top Expert Visual Basic Classic 2012 to 2014
In my profile you'll find links to some articles I've written that may interest you.
Marty - MVP 2009 to 2015, Experts-Exchange Top Expert Visual Basic Classic 2012 to 2014