Login Page - Create Account

Support Board

Date/Time: Tue, 23 Jan 2018 12:14:57 +0000

Post From: Cell Reference

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