Dear Richard, I have seen some of your videos, but there isn't any can solve my problem. I would like to know, how to filter some values which does not match in to tables which has almost same values.For example, table one has 100 items, and table 2 has 97 items. If i merge or combine these 2 table by some formula maybe, it should show the diffrence of those 3 items. (100-97=3). Please help me if there is anyway i can doo this in Excel. Thanking you in advance... Regards, Naga Singapore.
Reply from Richard Rost:
If all you want to do is COUNT the items in each table, then use the COUNT function and perform some subtraction.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Excel Forum.
