Results 1 to 2 of 2

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

Threaded View

bkforsythe Match and Sort two Columns... 11-06-2012, 06:05 PM
BB1972 Re: Match and Sort two... 11-06-2012, 07:07 PM
  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

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