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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Optimum Solution for range of values
1. first the values in column A
Then the Optimum value depends upon your criteria: =MAX(A:A) for the maximum value =MIN(A:A) for the minimum, etc -- Gary''s Student - gsnu200739 "KCG" wrote: 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 |
Reply |
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) |