Community Tip - Did you get an answer that solved your problem? Please mark it as an Accepted Solution so others with the same problem can find the answer easily. X
I would like to shift the values of the last part of a table. Is that possible?
Use the submatrix() function, possibly together with the stack() function.
Or do you mean to change their values instead of their position?
Success!
Luc
I would like to change the values of the last third or so, by a tiny bit.
I suppose I could maybe use the submatrix and stack to: disassemble, manipulate and reassemble.
Or is there an easier way?
if you wan to change the value of a vecor v, lets say at position 123, you can simply write v[123:=<any value you want>.
Or if you want it to increase by 1% you may write v[123:=1.01*v[123.
The "[" is the keyboard short for the vector index.
Something like this:
Success!Luc
Thanks!
I have never used such operations before. How do you get it to run?
Press the [F9] button.
(By default in my sheets, automatic calculation is switched off)
