Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Fri, 03 May 2024 11:03:58 +0000
Post From: New Spreadsheets INDEX function
| [2014-11-22 20:53:40] |
| |
|
This is disappointing. I extensively use INDEX in this way.
Provide us a simple example explanation which demonstrates a case which cannot be done due to this limitation. We would think it should not be difficult for us to implement another function to accomplish what you want.I offered a simple formula as an example. [There is another way to do it that works:=AVERAGE(OFFSET(E3,0,0,$K$1,1))] But more complex uses of INDEX cannot be easily replicated with other functions, if at all. You are used to doing things a certain way with the Old Spreadsheets based upon how those were designed. With the New Spreadsheets, there needs to be a new look at how to do things. If there is something you cannot do with New Spreadsheets, provide us a simple explanation of it that fits within the concept of spreadsheets, and we will see how to implement it within the general Spreadsheet framework. Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to the Teton service: Sierra Chart Teton Futures Order Routing Date Time Of Last Edit: 2014-11-22 21:04:24
|