Results 1 to 7 of 7

Lining up data with two colums of unequal length

Threaded View

  1. #1
    Registered User
    Join Date
    02-22-2016
    Location
    US
    MS-Off Ver
    10
    Posts
    6

    Lining up data with two colums of unequal length

    Hello,

    I have attached an excel file for clarity. Here is what I am trying to do:

    I have serial numbers in columns C and E (keep in mind this is a sample sheet and actual data is over 600 entries). I want to match up the serial numbers in column C with column E. Also, when I do this I want the corresponding model/color info from column F and G to stay with the serial number.

    I don't know if this matters but column E is longer than column C and therefore some numbers will not have a match. I don't know how this will affect things. There are no duplicate serial numbers.

    I have provided a sample sheet to show what I am trying to do. Any help is needed! I have been trying to figure this out for a while so I am seeking help!

    Thanks!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Lining up data from two different files
    By hk106 in forum Excel General
    Replies: 4
    Last Post: 08-30-2012, 01:16 PM
  2. How to Match and fill two lists of unequal length
    By artaxerxes in forum Excel General
    Replies: 6
    Last Post: 01-24-2012, 04:21 PM
  3. lining up data
    By Compton2004 in forum Excel General
    Replies: 1
    Last Post: 12-17-2008, 08:03 PM
  4. Lining Up Column Data
    By inwalkedbud in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-17-2008, 11:51 AM
  5. Series with noncontiguous unequal length data?
    By Bob@1800-mail.com in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 06-15-2006, 01:25 PM
  6. Lining up data from concatenation
    By Some Dude in forum Excel General
    Replies: 8
    Last Post: 06-05-2006, 02:35 PM
  7. [SOLVED] Lining up data from concatenation
    By Some Dude in forum Excel General
    Replies: 10
    Last Post: 06-05-2006, 02:35 PM
  8. Lining up data from two sheets
    By JoeZ in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-14-2005, 10:25 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