Results 1 to 14 of 14

Sum, index, match two columns and put into ascending order

Threaded View

  1. #1
    Registered User
    Join Date
    04-11-2014
    Location
    Iowa
    MS-Off Ver
    Office 2013
    Posts
    20

    Sum, index, match two columns and put into ascending order

    I've already been blessed from the forum with the formula to lookup this table, and put my entries in ascending order. My issue now is, when my panel lengths are the same, I want to sum the quantity needed, and put them into my work order/cut list as one entry, not 2 of the same length.

    Below the tables is what it should look like with the right formula, if possible.
    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. how to arrange multiple columns in ascending order
    By sanjay2210.msl in forum Excel General
    Replies: 2
    Last Post: 10-29-2013, 08:26 AM
  2. Replies: 3
    Last Post: 06-17-2013, 12:37 PM
  3. How to select two columns of values and sort them into ascending order,but w/o moving them
    By jonathancook in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-10-2013, 05:51 PM
  4. [SOLVED] Sorting Columns in Ascending Order
    By COLIN_303 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-17-2013, 07:51 AM
  5. [SOLVED] Generate "ascending order no" for columns of data that are not in order
    By abreichenbach in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 01-20-2013, 02:22 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