Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Fri, 03 May 2024 03:06:53 +0000
Beginner spreadsheet help with range in column?!
View Count: 515
| [2020-05-12 20:11:50] |
| User130862 - Posts: 19 |
|
Hello, First sorry for wasting valuable space here on support forum for questions likes this. I have just found out about spreadsheets and if I liked Sierra before I like it even more now. Read the documentation and followed it but receive #VALUE! error when trying to get the first 5 items in a specific column. Everything I have tried gives me #VALUE! error. Why I really don´t know. Tried this: =ID1.SG4@3:ID1.SG4@7 And this: =OFFSET(ID1.SG4@3, 0, 0, 5, 1)
And this: =AD3:AD7
But I always get #VALUE! "error". What am I doing wrong? |
| [2020-05-12 21:39:29] |
| |
|
And what do you want to do with those first 5 items? For example, you would want to use a formula like this: =SUM(ID0.SG4@3:ID0.SG4@7)
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: 2020-05-12 21:39:54
|
| [2020-05-13 11:06:00] |
| User130862 - Posts: 19 |
|
Greetings, I only want x amount of first cells in a column without any built in function. Reason is, since I have 5 different charts in chartbook with spreadsheet study. I get 5 sheets which is wonderful. However I will create a new blank sheet and then use reference to the other 5 with sheetname! but I want only top 5 cells of a specific column. Possible? #### EDIT #### Think I have found a work around by copy first formula and then paste it underneath the first one and then do this 5 times. =Sheet1!ID0.SG1@3 Did not realize the row ID changes automatically when pasting, great indeed! Once again I must praise the programmers who are involved in this magical software. You surprise me each day of how well designed and how powerful it really is. Date Time Of Last Edit: 2020-05-13 19:09:09
|
To post a message in this thread, you need to log in with your Sierra Chart account: