Results 1 to 5 of 5

Align 3 columns with 2 columns of matching data

Threaded View

  1. #1
    Registered User
    Join Date
    08-22-2013
    Location
    Kingston, Jamaica
    MS-Off Ver
    Excel 2010
    Posts
    3

    Align 3 columns with 2 columns of matching data

    Hi,

    I'm a newb and I'm sure this has been done before so bare with me.

    I need help to align first two columns and sort adjacent 3. I'm able to align using =IF(ISERROR(MATCH(A3,$DF$1:$DF$330,0)),"",A3), however sorting is eluding me. See below - I'm only posting a portion of the sheet because it has some 3000+ rows. Thanks for your help.

    Item Item Qty. on Hand Minimum On Order
    021-013 021-029 1 1 0
    021-015 110-014 4 4 0
    021-016 121-009 2 2 0
    021-028 122-602 58 75 26
    021-029 137-390 0 8 11
    110-014 137-452 2 3 0
    121-001 137-457 22 26 0
    121-007 145-951 5 5 0
    121-009 148-302 1 2 0
    122-602 156-001 1 2 0
    137-390 156-002 2 2 0
    Last edited by loritee; 08-23-2013 at 10:35 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Align Rows based on Matching Values in 2 Columns
    By cmv040 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-05-2016, 07:49 PM
  2. Excel 2007 : Align rows by matching values in other columns
    By jhanson60 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 05-14-2014, 11:27 PM
  3. [SOLVED] Align matching columns, then copy and paste data from one cell into another
    By Allisaursus in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-06-2013, 12:33 PM
  4. Align 3 columns with 2 columns of matching data
    By bearnbillie in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-04-2012, 08:33 AM
  5. Filtering Columns to Align Matching Data
    By Casino Guy in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-15-2005, 12:05 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