You can compare two worksheets using VBA if you have a lot of potential
differences using this:
http://www.exceltip.com/st/Compare_t...ce l/477.html
If you want a way to do it with formulas, please give more info on what's in
the worksheets.
"TotallyConfused" wrote in
message ...
I would like to know how is the easiest way to take two tables in Excel and
compare against each other and find for instance if there are no matches?
Any help will be greatly appreciated.