Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Data in narrow columns truncated when saving as DBF | Excel Discussion (Misc queries) | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
Convert 1 row of data into Multiple columns | Excel Discussion (Misc queries) | |||
How to take matching data from 2 columns and put in the same row? | New Users to Excel | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions |