+ Reply to Thread
Results 1 to 3 of 3

Need Help Matching and sorting multiple columns

Hybrid View

KA1485 Need Help Matching and... 03-11-2014, 02:16 AM
aydeegee Re: Need Help Matching and... 03-13-2014, 12:41 PM
Xx7 Re: Need Help Matching and... 03-13-2014, 01:44 PM
  1. #1
    Registered User
    Join Date
    03-11-2014
    Location
    United States
    MS-Off Ver
    Excel 20010
    Posts
    1

    Need Help Matching and sorting multiple columns

    I need help sorting a contact list of 3000 + so the emails match with the company name, and first and last name of the contacts

    Column A is Email and Matches column C & D. Column B matches with Column E. I need A to match with B-E.

    I've attached an example.Example Spreadsheet.xlsx

    Thanks!

  2. #2
    Valued Forum Contributor
    Join Date
    09-25-2011
    Location
    Eastbourne, England
    MS-Off Ver
    Excel 2010
    Posts
    1,089

    Re: Need Help Matching and sorting multiple columns

    Hi KA1485

    Welcome to the forum

    You have got yourself one heck of a job! It will be really easy if all email addresses were set to the same rules. That just isn't going to happen.

    I have written down some formulas that will extract certain data from the email address that might help you.

    Do not forget to make the entries into text before you start sortin, or you will get some very interesting results.

    Good luck

    Regards
    Alastair
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    01-30-2011
    Location
    Vancouver, Canada
    MS-Off Ver
    Excel 2010
    Posts
    604

    Re: Need Help Matching and sorting multiple columns

    As noted above, parse the data in Column A into Company First and Last name.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] [Help] Sorting Two Data columns/matching [Help]
    By Mattymul in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-25-2013, 01:06 PM
  2. Matching and Sorting with Two Columns
    By KaySwiss9 in forum Excel General
    Replies: 8
    Last Post: 07-26-2013, 02:22 AM
  3. Replies: 3
    Last Post: 06-09-2011, 05:58 AM
  4. Sorting and Matching Two Columns in Multiple Steps
    By macfarlane.a in forum Excel General
    Replies: 2
    Last Post: 10-26-2010, 08:39 PM
  5. [SOLVED] Sorting columns and Matching
    By Jeremy in forum Excel General
    Replies: 2
    Last Post: 07-21-2006, 03:00 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1