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
|