For simplicity’s sake, I have a RG that has 100 rows. Each row has a number and I want to do some math based on the value in the row above.
Say I have 5 rows, each looking like this:
Next to the value “5” I want to have a number that is 10-5 (10 from the row above).
The next row next to the value “8” I want to have a value that is 5-8.
The next row below that I want 8-2, then 2-4.
So basically each row takes the number from the row index above it. Not sure how to reference row index values in such as way. Possible?