| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting values from a list to add up to a specific quantity
I need a macro that will take values at random from a list of values an get them to add up to an exact quantity, constraints being that eac value that it uses must be from the original list, and each value ca be used only once. Right now I have it set up to split the values into two lists and the move individual values from one list to the other until one reaches th desired quantity - problem with this is that it takes too long an sometimes can't find a solution (there is ALWAYS a solution). Any ideas -- goos ----------------------------------------------------------------------- goose's Profile: http://www.excelforum.com/member.php...fo&userid=3053 View this thread: http://www.excelforum.com/showthread.php?threadid=54977 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| selecting randomly specific value in a list | Excel Worksheet Functions | |||
| selecting values from a list to equal a given value | Excel Worksheet Functions | |||
| selecting 20 closest values from a list of 200 values | New Users to Excel | |||
| Selecting values from a range that equal a specific total | Excel Worksheet Functions | |||
| Selecting amounts to display based on quantity | Excel Programming | |||
Threaded Mode
