If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Using Solver with the 'Frequency Array' Function
I'm having trouble setting up Solver to work with a Frequency array.
I'm wanting to set the Adustable Cells as the Bin values for the array, set contraints on the Frequency Results, with the Target Cell being the a sum of all frequency results, also constrained to the known total of data values. I've also set contraints on the Bin values so that they are = the next bin value. I always get a "Solver could not find a feasible solution". Any assistance would be great! |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Macros involving SOLVER... function | Pixies | General Discussion | 5 | April 20th, 2006 05:07 PM |
VBA function for "Mean" using Array as argument | ASokolik | Worksheet Functions | 20 | March 28th, 2006 08:57 PM |
Excel option to store trendline's coefficients in cells for use | Miguel Saldana | Charts and Charting | 9 | June 20th, 2005 08:45 PM |
simple and yet stupid question... Please help | tw | New Users | 11 | May 26th, 2005 07:45 PM |
Array Function with VLOOKUP | CoRrRan | Worksheet Functions | 13 | April 8th, 2005 05:54 PM |