R
RAquino
DATA SET: A1="1", B1="2", C1="3"
DESIRED RESULT:
1
2
3
INITIAL FORMULA SYNTAX: E1="=A1"
EXPECTED RESULT: 1
OBJECTIVE: To copy the formula horizontally (E1,E2, E3) while
referring to horizontal data (A1, B1, C1).
PROBLEM: If I were to copy the E1 formula to E2 and E3 the formula
variables would also increment vertically (number increments) so that
the formula syntax would be E2="=A2" and E3="=A3". The net result for
E1, E2, and E3 would be 1, 0, and 0 respectively.
QUESTION: Is there a script/function/method that I can create a data
set vertically and write formulas horizontally (or vice versa)? I used
a really simple example so that you may easily duplicate this problem
but can send you the far more complex spreadsheet if necessary.
I know that the simple, and proper practice would be just align all my
formulas in the same orientation that my data set is. I have been
contracted to provide the data and calculations in a very specific way
so that is out of the question.
Appreciate all the help!
DESIRED RESULT:
1
2
3
INITIAL FORMULA SYNTAX: E1="=A1"
EXPECTED RESULT: 1
OBJECTIVE: To copy the formula horizontally (E1,E2, E3) while
referring to horizontal data (A1, B1, C1).
PROBLEM: If I were to copy the E1 formula to E2 and E3 the formula
variables would also increment vertically (number increments) so that
the formula syntax would be E2="=A2" and E3="=A3". The net result for
E1, E2, and E3 would be 1, 0, and 0 respectively.
QUESTION: Is there a script/function/method that I can create a data
set vertically and write formulas horizontally (or vice versa)? I used
a really simple example so that you may easily duplicate this problem
but can send you the far more complex spreadsheet if necessary.
I know that the simple, and proper practice would be just align all my
formulas in the same orientation that my data set is. I have been
contracted to provide the data and calculations in a very specific way
so that is out of the question.
Appreciate all the help!