LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 7
Default 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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
create a random list of names from a list of names in EXCEL Givvie Excel Worksheet Functions 2 October 23rd 06 05:10 AM
Sorting a list of names by last name. Reb Excel Discussion (Misc queries) 3 March 17th 06 02:01 PM
Excel Spreadsheet from Access. List of names changes as names are Gordy w/Hi Expectations Excel Discussion (Misc queries) 1 October 21st 05 03:30 AM
eliminating extra rows in spreadsheet roger-e Excel Discussion (Misc queries) 2 August 19th 05 07:33 PM
sorting names alphabetically when names may start with numbers John Smith Excel Discussion (Misc queries) 3 May 11th 05 08:06 PM


All times are GMT +1. The time now is 06:35 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"