View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chris Brady Chris Brady is offline
external usenet poster
 
Posts: 1
Default Intersection of records in two spreadsheets

Please can someone advise?

I have two spreadsheets - in column A in both there is data listing
ACCOUNT_CODES. The other fields are all different. I need to find the
intersection (i.e. common records) between the two based on
ACCOUNT_CODES and list these in a third spreadsheet. There are about
30,000 records in each.

Many thanks - Chris B.