Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Comparing 2 pivot tables data using VBA | Excel Worksheet Functions | |||
Comparing two tables | Excel Discussion (Misc queries) | |||
Comparing tables in excel with formulas | Excel Discussion (Misc queries) | |||
Comparing 2 tables with similar content | Excel Discussion (Misc queries) | |||
Comparing data in tables | Excel Discussion (Misc queries) |