Hello all..
Little problem hopefully someone can help with-
If you want to split a number in a cell into equal amounts and what ever is left, left on its own. IE, split say, 150 into 2x55 and 1x40 or 55,55,40 etc.. is there any way to do this based on the split number ie weather its splits of 55's 40's etc etc...
Examples-
128 = 2x55 1x18 (55,55,18)
89 = 1x55 1x34 (55,34)
Thanks a lot
Si
Bookmarks