Merging Worksheets
Worksheet 1 has columns A & B which contain a sorted list of last names and
first names. Worksheet 2 has columns A, B, & C. Columns A & B contain a sorted list of last names and first names which is a subset of the list in worksheet 1. Column C is a count value. I would like to merge worksheets 1 & 2 to create worksheet 3 which contains a count value for every case where the last name-first name in worksheet 1 matches the last name-first name in worksheet 2, or zero where there is no match. This essentially an SQL join of worksheets 1 & 2 on Last Name and First Name. Can I do this in Excel? Anybody know how? Thanks. |
Merging Worksheets
you only want to count when both names match ,,, or when each surname \ first
name match "Michael Ryle" wrote: Worksheet 1 has columns A & B which contain a sorted list of last names and first names. Worksheet 2 has columns A, B, & C. Columns A & B contain a sorted list of last names and first names which is a subset of the list in worksheet 1. Column C is a count value. I would like to merge worksheets 1 & 2 to create worksheet 3 which contains a count value for every case where the last name-first name in worksheet 1 matches the last name-first name in worksheet 2, or zero where there is no match. This essentially an SQL join of worksheets 1 & 2 on Last Name and First Name. Can I do this in Excel? Anybody know how? Thanks. |
All times are GMT +1. The time now is 02:55 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com