andi1987uk
New Member
- Joined
- Apr 19, 2019
- Messages
- 7
Hi All,
Going to do my best to explain what I’m looking for here
.
So I’ve created a table that calculates a quantity of an item (eg the amount of pipe required for a project by room) this results in a range of pipe lengths. What I’m hoping for is a formula to group the data (as efficiently as possible) into the rolls the pipe is purchased in. So an example would be that I have 5 rows of data of metres of pipe lets say 50, 50, 100, 150 & 150 totalling 500 now let’s say the pipe is purchased in rolls of 100, 200 & 300 metres. To me the most efficient combination would be 1x 200 and 1x 300 rolls. Is there a formula that can help with this?
Thanks in advance
Andrew
Going to do my best to explain what I’m looking for here

So I’ve created a table that calculates a quantity of an item (eg the amount of pipe required for a project by room) this results in a range of pipe lengths. What I’m hoping for is a formula to group the data (as efficiently as possible) into the rolls the pipe is purchased in. So an example would be that I have 5 rows of data of metres of pipe lets say 50, 50, 100, 150 & 150 totalling 500 now let’s say the pipe is purchased in rolls of 100, 200 & 300 metres. To me the most efficient combination would be 1x 200 and 1x 300 rolls. Is there a formula that can help with this?
Thanks in advance
Andrew