| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Selecting data from a list based on entered values
I need to select data from a list based on certain values that I have
entered. I have a large amount of regression formulae and need to select thier coefficent values from the list based on the ranges of the input values. For example, if the input value is between 0 and 10, select list 1; if its between 10 and 20, select list 2 and so on. I have been struggling with this for a while and any help would be appreciated. |
|
#2
|
|||
|
|||
|
Hi
have a look at: http://www.xldynamic.com/source/xld.Dropdowns.html and http://www.contextures.com/xlDataVal02.html "GrantM" wrote: I need to select data from a list based on certain values that I have entered. I have a large amount of regression formulae and need to select thier coefficent values from the list based on the ranges of the input values. For example, if the input value is between 0 and 10, select list 1; if its between 10 and 20, select list 2 and so on. I have been struggling with this for a while and any help would be appreciated. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with data not getting plotted | Charts and Charting in Excel | |||
| Charting data ranges that change | Charts and Charting in Excel | |||
| Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) | |||
| HOW TO: Plot a Team Name on a chart based on two values | Charts and Charting in Excel | |||
| Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel | |||
Linear Mode
