Support Board
Date/Time: Sun, 24 Nov 2024 14:02:48 +0000
spreadsheet question
View Count: 182
| [2024-06-03 15:43:08] |
| User411320 - Posts: 289 |
|
Hello, how can I get a numbered column starting from 1 to X. For example, you can put "1" in a cell and pull down and it'll auto populate (2,3,4,5,) and so on.
|
 Screenshot 2024-06-03 111516.png / V - Attached On 2024-06-03 15:43:00 UTC - Size: 6.02 KB - 52 views |
| [2024-06-03 19:27:51] |
| John - SC Support - Posts: 36238 |
|
The easiest way to do this is to put this in a column that is not a "Calculation" column. With the default settings, this would start at Column AA and be all the columns to the right from there. In this case, enter a value of 1 in cell AA3, then enter the following in cell AA4: =AA3 + 1 Then select cell AA4 and select "Spreadsheet >> Copy Formula" and then left click and drag down to select down the column, then select "Spreadsheet >> Paste". For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2024-06-04 18:32:49] |
| User411320 - Posts: 289 |
|
that worked thanks
|
To post a message in this thread, you need to log in with your Sierra Chart account: