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
Is there any fomular can do that? (No code)
Thanks in advance.
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
Is there any fomular can do that? (No code)
Thanks in advance.
There's no formula that I know of & it is actually moe complicated than it looks.
probably need VBA to achieve this
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
You can do it using the Solver tool, not sure about Formula.
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
Cross posted here: http://www.mrexcel.com/forum/showthr...57#post2922557
bebo012999 please read this: http://www.excelguru.ca/node/7
Dom
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks