Forum Discussion
Solved
Excel- Split a number
Dear Sir, I am facing problem in excel for splitting a number into different random parts Like I want to split 45 into 7 random parts "1st part between 0-12" " 2nd part between 0-12" " 3rd ...
Dear Dr. Sharma
Please find a file that has a VBA script.
input your number in cell A1 (for example 45)
the function will use randbetween... until the sum will be 45
if you want 55, just change the value in cell A1
best regards
Press F9 to generate solutions
accepted solutions will become green
keep pressing F9 until all the column becomes green
hope this solution work, I dunno what to do with fractions (round up or down)
