View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Carl Carl is offline
external usenet poster
 
Posts: 361
Default Comparing 2 Tables

I have 2 tables:

TableA BOX050 BOX060 BOX355
A3 1 1
A7 1 1 1
AD 1 1
AR 1

TableB BOX050 BOX060 BOX355
A3 1
A7 1
AD 1
AR 1 1

Using TableA as the base table, I would like to check if Table B matches
Table B and if not, where the mismatches a

I thought about setting up another TableC that hase the same row and column
headings as TableA, then find a formula for the body of the table that will
look at TableB and highlight the mismatches - sort of like this:

TableC BOX050 BOX060 BOX355
A3 Check
A7 Check Check
AD Check
AR Check

Can a formula do this ?

That said, is there a better way to compare Table A with Table B.

Thank You in advance.