#1
|
|||
|
|||
Excel Calculation Problem
Hi,
I have a list of items in Excel, each of which has two values attached, credit and hours. There's a requirement that a choice of items needs to be made such that their total credit is above a certain value. I then need to find out which valid combination of units has the lowest number of hours. Example: Minimum credit from group = 10 Item 1 - 5 credits, 5 hours Item 2 - 5 credits, 5 hours Item 3 - 5 credits, 7 hours Item 4 - 10 credits, 12 hours I'd like this to return 'Minimum hours for group = 10' and ideally let me know that this is the combination of Items 1 & 2. If Item 4 had been, say, 8 hours, then that on its own would have been the smallest 'combination' meeting the rules. I'm not convinced Excel even knows how to do this, does anyone have any thoughts? I can find the minimum hours value per units but it's the caveat of a minimum total credit that's giving me trouble. Thanks, Ben |
#2
|
|||
|
|||
Hi Ben
Can you post a copy of your spreadsheet so we can see exactly what you have done so far. Tony(OTPM) |
#3
|
|||
|
|||
Quote:
After a bit of research I think Optimization is what I'm trying to do. I've installed the Solver but I'm stumped by it! Ben |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Help with 'hours worked' calculation... | Snvlsfoal | Excel | 1 | 08-11-2011 05:54 AM |
NETWORKDAYS calculation for entire column | Salient | Excel | 0 | 07-11-2011 03:58 PM |
Excel 2010 formula rounds - arithmetic average calculation | YooNaa Kim | Excel | 1 | 06-07-2011 08:50 PM |
how to make fields calculation variable according to the filter i use | duraid | Project | 0 | 09-09-2010 01:05 PM |
Mail Merge Calculation Error | Lsbutler2000 | Mail Merge | 1 | 06-22-2007 06:33 AM |