Results 1 to 5 of 5

Sorting by Index and Matching Formula

Threaded View

  1. #1
    Registered User
    Join Date
    03-05-2009
    Location
    Lester, IA
    MS-Off Ver
    Excel 2003
    Posts
    46

    Sorting by Index and Matching Formula

    I'm attempting to sort a list of containers and their corresponding quantities (A24:B28 in the attached spreadsheet) by using a combination of an index and match formula (cells A31:A35) and a large formula (cells B31:B35) in order to have the container with the largest quantity (summed in cells B24:B28) appear below in cells A31:A35 and the corresponding quantities in cells B24:B28.

    My current index and match formula works fine until I have the same quantities of different containers as I have replicated on the attached spreadsheet. When this is the case, the formula returns only one of the various container types. How do I edit the formula to allow for multiple containers with the same quantities?

    Thank you!
    Attached Files Attached Files
    Last edited by Cleman04; 07-07-2009 at 03:51 PM.

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