Results 1 to 6 of 6

Sum based conditional sorting

Threaded View

  1. #1
    Registered User
    Join Date
    05-22-2014
    Posts
    1

    Sum based conditional sorting

    Hello,

    I can't seem to find an answer, but it could be that I'm asking the wrong questions.

    I have some data with various items that have a cost, and a numeric value. What I'm trying to do is extract a list of items to buy up to a set limit that will produce the maximum combined value. I've managed to get as far as sorting the items based on value/cost, and stopping the list when I can't afford the next item(I left that out for now for clarity), but I can't seem to figure out how to continue past that to the next item I could still afford?

    For example in the attached you will see that while I can't afford Item I, I should still be able to buy Item B.

    Would someone please help point me in the right direction?

    Thanks,
    B
    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. Conditional sorting problem
    By ronbrockbank in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-10-2014, 09:39 PM
  2. [SOLVED] Conditional Sorting
    By djh30 in forum Excel General
    Replies: 2
    Last Post: 07-08-2013, 01:23 PM
  3. Sorting with conditional formatting
    By skip2mylew in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-06-2013, 02:12 PM
  4. Copying specific cell based on two parameters and then sorting based on one parameter
    By buntalan80 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-17-2012, 02:27 AM
  5. conditional sorting
    By Ahmad1 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-24-2011, 07:04 AM
  6. Sorting and Delete rows meeting criteria based on sorting criteria
    By ron2k_1 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-10-2011, 02:40 PM
  7. Conditional sorting
    By Psyke45 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-24-2007, 10:51 AM
  8. [SOLVED] Conditional Sorting
    By Rob in forum Excel General
    Replies: 1
    Last Post: 09-16-2005, 09:05 PM

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