Conversation Dividing lengths from a roll in Excel
https://techcommunity.microsoft.com/t5/excel/dividing-lengths-from-a-roll/m-p/836545#M39400
<P>I've been trying to solve a problem on excel; I have a data set of about 250 lengths of material, varying between 50 and 700 feet in no particular pattern, and I must find ways to go down this list and show where a roll of 2500 feet would run out somehow. Would this be a group function, or a sum function, or what would the smartest way to tackle this problem? Note that the data shouldnt be re-sorted, it has to stay in it's current order, and is subdivided already into groups, so I'm not sure if theres a way to automatically highlight the groups of 2500 or otherwise show where the groups would be on the sheet.</P><P> </P><P>Thanks,</P><P>-Newb</P><P> </P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture.PNG" style="width: 518px;"><img src="https://gxcuf89792.i.lithium.com/t5/image/serverpage/image-id/130085i6B06D9BCC67EB22B/image-size/large?v=1.0&px=999" title="Capture.PNG" alt="Capture.PNG" /></span></P>Wed, 04 Sep 2019 12:53:51 GMTMitchell_Cottew2019-09-04T12:53:51ZDividing lengths from a roll
https://techcommunity.microsoft.com/t5/excel/dividing-lengths-from-a-roll/m-p/836545#M39400
<P>I've been trying to solve a problem on excel; I have a data set of about 250 lengths of material, varying between 50 and 700 feet in no particular pattern, and I must find ways to go down this list and show where a roll of 2500 feet would run out somehow. Would this be a group function, or a sum function, or what would the smartest way to tackle this problem? Note that the data shouldnt be re-sorted, it has to stay in it's current order, and is subdivided already into groups, so I'm not sure if theres a way to automatically highlight the groups of 2500 or otherwise show where the groups would be on the sheet.</P><P> </P><P>Thanks,</P><P>-Newb</P><P> </P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Capture.PNG" style="width: 518px;"><img src="https://gxcuf89792.i.lithium.com/t5/image/serverpage/image-id/130085i6B06D9BCC67EB22B/image-size/large?v=1.0&px=999" title="Capture.PNG" alt="Capture.PNG" /></span></P>Wed, 04 Sep 2019 12:53:51 GMThttps://techcommunity.microsoft.com/t5/excel/dividing-lengths-from-a-roll/m-p/836545#M39400Mitchell_Cottew2019-09-04T12:53:51Z