LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5
Default How to Determine group of numbers best fit into 1 number

I am trying to determine the following:

I have 3 sizes of product I need to cut from different width sheets of
aluminum. (the lenght is all the same so length is not needed in formula).

Blank size width:

10 inches
15 inches
20 inches

Available aluminum Sheet widths:

36 inches
48 inches
60 inches

What I want to determine is when I put in width sizes the program would
automatically figure the quantity of the optimal size sheets to use in order
to cut down on waste since aluminum is expensive. The width size of the
blanks will vary from job to job. The available aluminum sheet widths are
always the sizes I have above.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Count every group of numbers whose sum is zero & put formula next toeach number al Excel Worksheet Functions 7 March 17th 09 01:19 PM
How do I select a number from a specific group of numbers? motol Excel Worksheet Functions 2 August 24th 06 05:52 AM
How can I convert a group of numbers to a group of letters? CarlG Excel Worksheet Functions 9 August 18th 06 03:31 PM
Can VBA determine if a cell/range is in a group? BlindGuardian Excel Programming 7 June 10th 05 08:12 PM
Can VBA determine if a cell/range is in a group? Ron Coderre[_11_] Excel Programming 0 June 10th 05 06:49 PM


All times are GMT +1. The time now is 10:11 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright 2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"