K
kk
Hello everybody!
I am able to create csv files that contain functions that are readable
from excel.
For example the following .csv file:
10,20,30
20,30,40
=AVERAGE(A1:A2),=AVERAGE(B1:B2),=AVERAGE(C1:C2)
when opened from excel prints the following table:
A B C
1 10 20 30
2 20 30 40
3 15 25 35
Instead of defining the specific cells that the Average function
should use as an input, i want to say something lile:
"Calculate the average of the two cells above this cell".
Something like saying
=Average(column[this]line[-2]:column[this]line[-1])
Sound familiar to anyone?
Thanks in advance!
I am able to create csv files that contain functions that are readable
from excel.
For example the following .csv file:
10,20,30
20,30,40
=AVERAGE(A1:A2),=AVERAGE(B1:B2),=AVERAGE(C1:C2)
when opened from excel prints the following table:
A B C
1 10 20 30
2 20 30 40
3 15 25 35
Instead of defining the specific cells that the Average function
should use as an input, i want to say something lile:
"Calculate the average of the two cells above this cell".
Something like saying
=Average(column[this]line[-2]:column[this]line[-1])
Sound familiar to anyone?
Thanks in advance!