Support Board
Date/Time: Fri, 17 Jan 2025 23:19:32 +0000
Post From: Cell Reference
| [2018-01-02 21:04:14] |
| User612649 - Posts: 40 |
|
In the spreadsheet, how do I reference the value or tell the spreadsheet to follow the cell when doing its calculations. Example: ID0.SG1@3 Value: 24779 I want to reference this same value when it moves down to ID0.SG1@4, or just save the value. Absolute specifies the cell which is not what I want. Relative will reference back to ID0.SG1@3 which is not what I want. I want it to follow that specific cell or if I can, extract and save the value from that cell. I tried INDIRECT(ID0.SG1@3). This didn't work. Can I pull the content or numerical value from the cell and store it in a "J" column cell? Date Time Of Last Edit: 2018-01-03 01:52:50
|