Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 846
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 4,339
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do you compare 2 different spreadsheets for duplication? hiziggie Excel Worksheet Functions 1 September 11th 06 11:16 PM
how can I compare two excel spreadsheets? Kathy Excel Worksheet Functions 1 July 12th 06 08:56 PM
Compare Two Spreadsheets Ty Excel Discussion (Misc queries) 1 February 15th 06 06:09 PM
How do I compare the difference in two spreadsheets? Daysi Excel Worksheet Functions 1 November 22nd 05 07:00 PM
How can I compare to spreadsheets Comparing similar data betwee two spread Excel Worksheet Functions 1 November 23rd 04 05:51 PM


All times are GMT +1. The time now is 07:27 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"