Login Page - Create Account

Support Board


Date/Time: Thu, 19 Jul 2018 05:57:25 +0000



Post From: Cell Reference

[2018-01-02 21:04:14]
User612649 - Posts: 9
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