Auto format formula

[davidedmunds]

I am working with a worksheet to try and update another worksheet, what I need to create is a formula that when it reaches the figure 9 that the any remaining numbers drop into the next column,

if anyone can help with this it would be great

[Richard Buttrey]

Hi,

Welcome to the forum.

You'll need to upload an example workbook showing a before and after situation. It's not obvious from your post exactly what you want to see.

It would also assist you to get more responses if you choose a better title. I'd suggest one except that I don't yet understand precisely what you want to do.

[davidedmunds]

Please find the excel document

Thanks for looking

[:) Sixthsense :)]

Paste the below formula in H13 cell and Drag it to Right

=IF((SUM($D$13:$D$17)/(COLUMNS($H$1:H1)*9))>1,9,IF(SUM($D$13:$D$17)-((COLUMNS($H$1:H1)-1)*9)>0,SUM($D$13:$D$17)-((COLUMNS($H$1:H1)-1)*9),""))

Hope this helps!