Community Tip - Need to share some code when posting a question or reply? Make sure to use the "Insert code sample" menu option. Learn more! 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)
