View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
TotallyConfused
 
Posts: n/a
Default Please help how to Compare tables in Excel



"Barb Reinhardt" wrote:

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.