+ Reply to Thread
Results 1 to 2 of 2

Match and Sort two Columns and keep other columns linked to a particluar column

  1. #1
    Registered User
    Join Date
    11-06-2012
    Location
    Irving
    MS-Off Ver
    Excel 2003
    Posts
    1

    Match and Sort two Columns and keep other columns linked to a particluar column

    I have three columns of data. I need to match up the part numbers in column E to the part numbers in Column F. Column H relates to Column F and must be kept together with the data in column F. There will be some part numbers that do not have a match. Those need to be sorted at the bottom when finished.

    For Example:
    Column E Column F Column H
    100247 100247 82.10
    100309 100313 55.10
    100319 100319 57.80
    100378 100341 11.90
    101577 100378 24.30

    I need it to look like:
    Column E Column F Column H
    100247 100247 82.10
    100309
    100319 100319 57.80
    100378 100378 24.30
    101577
    100313 55.10

    Not sure where to start on this to match up columns with out losing Column H in the process.
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    07-27-2012
    Location
    Dublin, Ireland
    MS-Off Ver
    Excel 2010
    Posts
    826

    Re: Match and Sort two Columns and keep other columns linked to a particluar column

    bkforsythe, welcome to the forum.

    A good place to start would be to with the format of the "numbers" in Column E. They are mainly preceded by an apostrophe, so even though they (visually) appear to be the same as some entries in Column F, Excel cannot match them, as '100247 is not the same as 100247.
    Brendan.


    __________________________________________________________________________________________________
    Things to consider:

    1) You can thank any poster by clicking the * at the left of a helpful post.
    2) You can help to keep the forum tidy by marking your thread as "Solved", if it has been answered to your satisfaction.
    3) Help us to help you, by uploading a sample workbook, showing the type of data you're dealing with, and clearly indicating what the results should be.

+ 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