| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sorting and matching rows of names with Socials with master list and eliminating the extra names
Sorting and matching rows of names with Socials with master list and
eliminating the extra names That arent on the master list. The master list consists of 739 names and the Names with Social consist of 1263. I need to match the social with the 739 Names on the master list. Anyway to automate this? Ex. Column A MASTER LIST Amy Dexter Rick Suzie Tom Column B NAMES Amy Beth Dexter Pat Rick Suzie Tom Column C Socials xxx-xx-xxxx xxx-xx-xxxx xxx-xx-xxxx xxx-xx-xxxx xxx-xx-xxxx xxx-xx-xxxx xxx-xx-xxxx |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sorting and matching rows of names with Socials with master listand eliminating the extra names
Insert a blank column between the Master List and the Names columns.
In the new column, enter a VLookup formula, to pull the numbers that match the name. For example, in cell B2: =VLOOKUP(A2,$C$2:$D$1264,2,0) Giacomo wrote: Sorting and matching rows of names with Socials with master list and eliminating the extra names That arent on the master list. The master list consists of 739 names and the Names with Social consist of 1263. I need to match the social with the 739 Names on the master list. Anyway to automate this? Ex. Column A MASTER LIST Amy Dexter Rick Suzie Tom Column B NAMES Amy Beth Dexter Pat Rick Suzie Tom Column C Socials xxx-xx-xxxx xxx-xx-xxxx xxx-xx-xxxx xxx-xx-xxxx xxx-xx-xxxx xxx-xx-xxxx xxx-xx-xxxx -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| create a random list of names from a list of names in EXCEL | Excel Worksheet Functions | |||
| Sorting a list of names by last name. | Excel Discussion (Misc queries) | |||
| Excel Spreadsheet from Access. List of names changes as names are | Excel Discussion (Misc queries) | |||
| eliminating extra rows in spreadsheet | Excel Discussion (Misc queries) | |||
| sorting names alphabetically when names may start with numbers | Excel Discussion (Misc queries) | |||
Linear Mode
