ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Trouble with linset (https://www.excelbanter.com/excel-worksheet-functions/258023-trouble-linset.html)

confused

Trouble with linset
 
When I enter in linset and hit ctrl shift enter it still doesn't display the
information as an array, what is the problem?

Mike Middleton

Trouble with linset
 
Confused -

Select a large range of cells first. Then in the formula bar enter
=LINEST(...,...,...,...) with the appropriate arguments. Finally instead of
pressing Enter, hold down Ctrl and Shift while you press Enter.

- Mike
http://www.MikeMiddleton.com


"Confused" wrote in message
...
When I enter in linset and hit ctrl shift enter it still doesn't display the
information as an array, what is the problem?



All times are GMT +1. The time now is 05:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com