Support Board
Date/Time: Wed, 05 Feb 2025 09:43:09 +0000
[Programming Help] - Cell referencing w/ the @
View Count: 530
| [2020-03-05 17:32:40] |
| User917679 - Posts: 76 |
|
Is it possible to use a cell refence to designate the row number? And if so, what is the notation? so if we wanted "@3", how would we go about using a cell reference in lieu of that 3? I tried putting a number "3" in H3 and typed "@H3".. but that obviously didn't work.... |
| [2020-03-05 17:57:49] |
| Sawtooth - Posts: 4167 |
|
That format only works for values from subgraphs. Working with Spreadsheets: References to Study Subgraph Columns when using the Spreadsheet Study The number after the @ is the row. Use the standard Column/Row format to reference all other cells, e.g.: A4, H1, J8 |
| [2020-03-05 18:37:37] |
| User917679 - Posts: 76 |
|
I believe the index function will work with what I'm trying to do. Thanks again |
To post a message in this thread, you need to log in with your Sierra Chart account: