Support Board
Date/Time: Tue, 15 Apr 2025 14:29:11 +0000
spreadsheet study question about using value as reference
View Count: 52
| [2025-04-03 05:04:07] |
| User488241 - Posts: 41 |
|
If I calculate a integer numerical value, is there a way I can reference that cell as the range amount for another cell? For instance, I calculate the integer 5 in cell k3. I want to use the following expression min(e3:e(k3)) How would I go about accomplishing this? Thank you! |
| [2025-04-03 05:51:58] |
| Sierra_Chart Engineering - Posts: 19226 |
|
We have to look into this. Should not be difficult if we do not have this already to create a function that can return a range reference based upon, all integer values. Top left row column, bottom right row column.
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, use the Teton service: Sierra Chart Teton Futures Order Routing Date Time Of Last Edit: 2025-04-03 05:52:22
|
| [2025-04-03 13:25:42] |
| Sawtooth - Posts: 4202 |
|
If I calculate a integer numerical value, is there a way I can reference that cell as the range amount for another cell?
This should work:=MIN(E3:OFFSET(E3,K3-3,0)) Or this, if K3 is absolute: =MIN(E3:OFFSET(E3,K$3-3,0)) |
To post a message in this thread, you need to log in with your Sierra Chart account: