Combination with defined set of numbers

[phazescan]

Here's what I'd like to do:

I need a formula(s) that determines which numbers from a list of numbers can be combined so that they DO NOT exceed another pre-defined number.

EX: 22.9, 8.1, 4, 22.9, 22.9 are listed numbers. They must be organized so that they do not exceed 32. So the answer would be something like: 22.9, 31, 26.9 OR 22.9, 22.9, 22.9, 12.1. The first answer being the best as it creates the least amount of results. Make sense?

[shivya]

=randbetween(20,31)

[Shareez Saleem]

Enter the formula in a cell =RANDBETWEEN(12,31)+ROUNDDOWN(RAND(),1) and drag down.
Use rank function =RANK(A1,$A$1:$A$12,1) in another cell and drag down.
Later you can copy and paste (only values) and sort the data according to your needs.

[José Augusto]

If I understood your problem well, it is deterministic and not random.

The solution I propose requires that your list be sorted in descending order.

Assuming the data in B3:B7, use the following formula in D3 and copy down.

Please Login or Register  to view this content.

See the file for clarification