Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to match and compare two spreadsheets
I have two tables of data each with one common key. I'd like an excel
function that can bring both tables together by matching the key column and identify items on each of the tables that have no match so no data is lost. NB- the common key can be numeric or alhp-numeric. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to match and compare two spreadsheets
See he
http://www.cpearson.com/excel/duplic...tractingCommon "Brad" wrote: I have two tables of data each with one common key. I'd like an excel function that can bring both tables together by matching the key column and identify items on each of the tables that have no match so no data is lost. NB- the common key can be numeric or alhp-numeric. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you compare 2 different spreadsheets for duplication? | Excel Worksheet Functions | |||
how can I compare two excel spreadsheets? | Excel Worksheet Functions | |||
Compare Two Spreadsheets | Excel Discussion (Misc queries) | |||
How do I compare the difference in two spreadsheets? | Excel Worksheet Functions | |||
How can I compare to spreadsheets | Excel Worksheet Functions |