Link to home
Start Free TrialLog in
Avatar of eemoon
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
Avatar of Martin Liss
Martin Liss
Flag of United States of America image

Can you post the workbook and tell us how you want the difference reported?
Avatar of eemoon
eemoon

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 ?
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?
Avatar of eemoon

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
Avatar of Martin Liss
Martin Liss
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of eemoon

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
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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