| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using Solver with Data Table
Hi,
I have created a one-entry data table with 1000 trials. I want to use Solver to minimize the average value in the data table by changing weights on a corresponding portfolio. However, when I manually change the weights and then ask Solver to re-solve, it gives me a different result. Any one have any ideas? Does Solver not work well with data tables? Is there a way around this? Thank you!! Latika |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Pivot Table Plugin? (crosstab to data table) | Excel Discussion (Misc queries) | |||
| using solver to complete a table | Excel Worksheet Functions | |||
| Interesting Solver problem (Solver encounters an error) | Excel Discussion (Misc queries) | |||
| solver table | Excel Discussion (Misc queries) | |||
| Solver Table missing in Data Menu of Excel2003. Where is it? | Excel Worksheet Functions | |||
Threaded Mode
