| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Optimum Solution for range of values
Hello all,
Please help! I have a range of values between 1 and 20 as follows: 18 3 15 9 2 4 11 5 13 16 20 1 14 3 8 17 11 How do I use Excel/Visual Basic to determine a single optimum value in the range? Some values are repeated. (I'm not looking for the average). Do I use Solver; Monte Carlo Simulation; Integer Programming interfaced with Excel???? Any help will be appreciated. Regards -- KCG |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Solution for charting IF statements that return blank values | Charts and Charting in Excel | |||
| Can Excel solve this or get to optimum. | Excel Discussion (Misc queries) | |||
| Find dates in a range; then sum values in that range by a criteria | Excel Discussion (Misc queries) | |||
| Optimum requirements for Excel | Excel Discussion (Misc queries) | |||
| Hardware for optimum Excel performance | Excel Discussion (Misc queries) | |||
Threaded Mode
