Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Need to analyze list of numbers and build groups of cells that meet my target cell (or as close)
Register FAQ Mark Forums Read

Reply
 
Thread Tools Display Modes
  #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, 9 views)
Reply With Quote
  #2  
Old 07-06-2017, 01:11 PM
NoSparks NoSparks is offline Need to analyze list of numbers and build groups of cells that meet my target cell (or as close) Windows 7 64bit Need to analyze list of numbers and build groups of cells that meet my target cell (or as close) Office 2010 64bit
Excel Hobbyist
  
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 831
NoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really nice
Default
Any kerf allowance ?
Reply With Quote
  #3  
Old 07-06-2017, 01:57 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 3mm per cut
3 mm per cut
Reply With Quote
  #4  
Old 07-06-2017, 11:02 PM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Need to analyze list of numbers and build groups of cells that meet my target cell (or as close) Windows 7 64bit Need to analyze list of numbers and build groups of cells that meet my target cell (or as close) Office 2010 64bit
Expert
  
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,770
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default
Have you searched the Net ? This problem has been solved many times
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #5  
Old 07-06-2017, 11:05 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
Quote:
Originally Posted by Pecoflyer View Post
Have you searched the Net ? This problem has been solved many times

I am happy for some links if it has.
Maybe I didnt search for correct keywords.
Reply With Quote
Reply

« Previous Thread | Next Thread »
Thread Tools
Display Modes
Linear Mode Linear Mode


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:27 PM.

Contact Us - Privacy Statement - Top

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