Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Comparing tables in excel with formulas
How can you compare two tables in excel to identify matches and no matches
using formulas. For instance both tables have the same information. The only unique information would be first name and last name but different cities. Any help will be greatly appreciated. Thank you. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Comparing tables in excel with formulas
Hi TotallyConfused,
See Chip Pearson's Duplicates page for various suggestions: http://www.cpearson.com/excel/duplic...tingDuplicates If you wish to compare multi-column tables, you could, perhaps, add a helper column to each table: in the helper columns add an appropriate concatenation formula, e.g.: = A2 & B2 & D2 where columns A,B and C house the first name, last name and city data Then run the comparison tests on the concatenated helper columns. --- Regards, Norman "TotallyConfused" wrote in message ... How can you compare two tables in excel to identify matches and no matches using formulas. For instance both tables have the same information. The only unique information would be first name and last name but different cities. Any help will be greatly appreciated. Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
scalable headings in Microsoft Excel when editing long formulas | Excel Discussion (Misc queries) | |||
Excel 2002; copy formulas to one workbook to another diff data | Excel Worksheet Functions | |||
Excel formulas and recalculation | Excel Discussion (Misc queries) | |||
Excel Formulas | Excel Discussion (Misc queries) | |||
How do I get to master Excel functions and formulas? | Excel Worksheet Functions |