Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I'm trying to compare 3 tables (same fields) to check and see if any data is
different. The layout is the same only the data will be different (Base Table, Current Table, New Table) Table 1: Base Family Sub Grade TMI TMI50 1 229 23 1 $70,500 1 229 23 3 $75,000 3 450 22 1 $185,000 5 220 24 3 $160,000 Table 2: Current Family Sub Grade TMI TMI50 1 229 23 1 $70,500 1 229 23 3 $75,000 3 450 22 1 $185,000 5 220 24 3 $160,000 Table 3: New Family Sub Grade TMI TMI50 1 229 23 1 $70,500 1 228 23 3 $75,000 3 450 22 1 $185,000 5 220 25 3 $164,000 I want to run a comparison that will compare every row and "point out" whatever differences there maybe. I know there are some because I have the same exact number of rows in Base and Current, but about 50 more in the New table. Any thoughts? Thanks! Michele |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Array Formulas take waaaay too long... | Excel Worksheet Functions | |||
Need Formulas for counting multiple conditions | Excel Worksheet Functions | |||
Help, Urgent Excel Formulas are not calculating | Excel Discussion (Misc queries) | |||
Problem with named formula's | Excel Worksheet Functions | |||
calculating formulas for all workbooks in a folder | Excel Worksheet Functions |