Forum Discussion
Excel- Split a number
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
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
Sir, I got stuck in my original file.
Can you give a generous solution for the attached file?
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)
Hey Ramiz, can you help me out?
I tried your formula, but it does not work here.
https://docs.google.com/spreadsheets/d/1kYxrx9zcjY2Ap1o4nAw5sYs5d7BAhXVD/edit?usp=sharing&ouid=100527059548267574176&rtpof=true&sd=true
