Choose 3 numbers from list

[bebo021999]

Deal all,
I have a list from A1:A5, for ex: 10;15;40;47;50;51
I'd like to pick 3 numbers from list, that total is 100.
The result should be: 10;40;50 in B2,C2,D2
Is there any fomular can do that? (No code)
Thanks in advance.

 

[repairman615]

Hello,

You could add checkboxes (forms control )next to the numbers in the list.

Then right click each checkbox and choose format control. Find linked cell and choose an unsused column to link to in the same row.

This will place a true or false in the column depending on if the checkbox is ticked.

Now use a formula like

=SUMIF(D1:D4,"True",A1:A4)

Where D1:D4 is the column of true and false, and A1:A4 is the range of numbers.

 

[Domski]

Cross posted here:

http://www.excelforum.com/excel-general/800300-how-to-choose-numbers-from-a-list.html

bebo012999 please read this: http://www.excelguru.ca/node/7

Dom