View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JohnS
 
Posts: n/a
Default MATCHING DATA IN COLUMNS

I have 2 spreadsheets containing names, addresses, d.o.b. etc as column
headings.

I want to identify in the first spreadsheet those records where the data
under the column headings: surname, forename,d.o.b. exactly match any records
in the second spreadsheet.

It would be useful if I could locate the identified rows to a third
spreadsheet.

Spreadsheet 1 has 450 rows, spreadsheet 2 has 14,000 rows.

Any help much appreciated