Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 07-06-2017, 12:33 PM
Jeremy Jeremy is offline Need to analyze list of numbers and build groups of cells that meet my target cell (or as close) Windows 10 Need to analyze list of numbers and build groups of cells that meet my target cell (or as close) Office 2016
Novice
Need to analyze list of numbers and build groups of cells that meet my target cell (or as close)
 
Join Date: Jul 2017
Posts: 3
Jeremy is on a distinguished road
Default Need to analyze list of numbers and build groups of cells that meet my target cell (or as close)

I have a list of items that are a specific length. I need to group the items together (need a way to mark each group) that will be equal or smaller than the target number.
It would have to find the best combinations that would get each group as close as possible to the target length.

Real world story:
I have orders for profiles at requested lengths.
I have stock of profiles at 4.3.
I need a way to group the items that are the best to cut from a single profile.


Need to find the groups that would create the least amount of waste.
Attached Files
File Type: xlsx Target group for cutting.xlsx (10.5 KB, 11 views)
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Need to analyze list of numbers and build groups of cells that meet my target cell (or as close) Conditional Formatting if certain cell meet certain conditions bbutl027 Excel 1 11-25-2016 12:52 AM
Need to analyze list of numbers and build groups of cells that meet my target cell (or as close) How can I build figures list and tables list separately lopesdasilva Word 2 05-31-2016 01:30 AM
Need to analyze list of numbers and build groups of cells that meet my target cell (or as close) convert list in one cell into multiple cells RayK Excel 2 02-09-2016 04:53 AM
Arranging x numbers in y groups with an approximate sum of z hiwire03 Excel 0 12-11-2014 10:14 PM
How to count cells containing data and meet certain criteria AdamNT Excel 1 08-11-2006 11:51 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:46 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft