| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Linest function: data selection problems
Since upgrading from 2002 to 2003 a spreadsheet that worked is now not
working correctly. The formula is not calculating the selected data correctly. The formula is =INDEX(LINEST(D12:O16,D37:O41,,FALSE),1) Excel is having a problem selecting data on multiple rows. A test has been carried out when the data was moved into one column or one row and it worked. It appears excel is now only taking into account the first row of data. Is there an option that needs to be selected for it to work? The help files were compared between the versions of excel and there is no difference. The objective of the formula is to calculate a regression line. If you require more information please ask. Thank you Nathan |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| pivot table with selection values not included in the base data | Charts and Charting in Excel | |||
| Web Services function call and data refreshing | Excel Worksheet Functions | |||
| Macro data selection line delete | Excel Discussion (Misc queries) | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
| Charting data ranges that change | Charts and Charting in Excel | |||
Threaded Mode
