Login Page - Create Account

Support Board


Date/Time: Tue, 16 Oct 2018 07:09:22 +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