Forum Discussion
Excel formula help
Good Day,
I will try to explain to the best i can what i am trying to do!? i have uploaded the image with a better view to understanding what i am trying to achieve.
i basically have a list of numbers (stock Layers Items) going down in rows on a column.
There are 9 Layers to a Pallet - So i would basically like to paste the layers in the column then id like it to automatically assign the layers to the pallets, when 9 layers are reached the formula to pull through to the next pallet.
I hope this make sense to some one and your help is much appreciated.
Replicated your sheet and believe that this formula will do what you need.
=IF((SUM(F$5:F5)+$D6-SUM($E6:E6))<=9,$D6-SUM($E6:E6),9-SUM(F$5:F5)+SUM($E6:E6))Important that column E remains empty and the the headers in row 5 are text (i.e. not numbers) or that you insert an empty row 5. Enter the formula in F6 and copy it down and across as far as you need.
9 Replies
Replicated your sheet and believe that this formula will do what you need.
=IF((SUM(F$5:F5)+$D6-SUM($E6:E6))<=9,$D6-SUM($E6:E6),9-SUM(F$5:F5)+SUM($E6:E6))Important that column E remains empty and the the headers in row 5 are text (i.e. not numbers) or that you insert an empty row 5. Enter the formula in F6 and copy it down and across as far as you need.
Riny_van_Eekelen That works perfectly thank you so much!! i have been trying to work this out for WEEKS!
marc47555 Glad it worked!
