Home

Dividing lengths from a roll

%3CLINGO-SUB%20id%3D%22lingo-sub-836545%22%20slang%3D%22en-US%22%3EDividing%20lengths%20from%20a%20roll%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-836545%22%20slang%3D%22en-US%22%3E%3CP%3EI've%20been%20trying%20to%20solve%20a%20problem%20on%20excel%3B%20I%20have%20a%20data%20set%20of%20about%20250%20lengths%20of%20material%2C%20varying%20between%2050%20and%20700%20feet%20in%20no%20particular%20pattern%2C%20and%20I%20must%20find%20ways%20to%20go%20down%20this%20list%20and%20show%20where%20a%20roll%20of%202500%20feet%20would%20run%20out%20somehow.%20Would%20this%20be%20a%20group%20function%2C%20or%20a%20sum%20function%2C%20or%20what%20would%20the%20smartest%20way%20to%20tackle%20this%20problem%3F%20Note%20that%20the%20data%20shouldnt%20be%20re-sorted%2C%20it%20has%20to%20stay%20in%20it's%20current%20order%2C%20and%20is%20subdivided%20already%20into%20groups%2C%20so%20I'm%20not%20sure%20if%20theres%20a%20way%20to%20automatically%20highlight%20the%20groups%20of%202500%20or%20otherwise%20show%20where%20the%20groups%20would%20be%20on%20the%20sheet.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3CP%3E-Newb%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20518px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F130085i6B06D9BCC67EB22B%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Capture.PNG%22%20title%3D%22Capture.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-836545%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Mitchell_Cottew
Occasional Visitor

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.

 

Thanks,

-Newb

 

Capture.PNG

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
38 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies