+ Reply to Thread
Results 1 to 2 of 2

Matching and sorting Data from two different columns?

Hybrid View

  1. #1
    Registered User
    Join Date
    08-16-2010
    Location
    alberta, canada
    MS-Off Ver
    Excel 2007
    Posts
    1

    Matching and sorting Data from two different columns?

    Hello there... I am VERY new to Excel 2007 and need help with the following;

    I have 3 columns of Data.. A, B, C. Columns B and C are related in that column B has numbers and Column C is a description of those numbers (client information, every number in A and B is a client.)

    Column A has numbered clients from 24-9000 with about 1200 missing numbers in that range (a shortlist of clients, thus the missing #'s)
    Column B has numbered clients from 11-13500 with NO missing numbers (older Main/Master list of clients).

    I want to line up both column A and B so that any LIKE numbers line up from top to bottom, keeping in mind that Column C is Text that corresponds to Column B and must 'line-up' with Column B numbers once 'sorted'.

    Any 'excess' numbers and text from Columns B and C that are NOT FOUND in Column A are of no consequence and will be deleted.

    Thanks for any help you can provide!

    Cheers,

  2. #2
    Forum Contributor meyero90's Avatar
    Join Date
    03-24-2010
    Location
    New York
    MS-Off Ver
    Excel 2007
    Posts
    202

    Re: Matching and sorting Data from two different columns?

    Hello and welcome to the forum. Is there a way you can attach a spreadsheet with some dummy data in it, in order to better understand your request. Thank you.
    To attach. Go Advanced>scroll down>you'll see the option to attach a file.
    If I helped, Don't forget to add to my reputation (click on the little scale)
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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