B
balhal
Can you generate a table in Excel without using a Macro, Pivot Table or VB?
A1 has a user input. B1 = 3*A1. I want to create a table as follows
Input Result
2 6
3 9
-4 -12
I suspect you can use one of the pointer functions to tell Excel where to
store the next result, but I can’t figure out how to do that – is there
something equivalent to a STORE command.
Another thought is to have the table cells check the user input to see if
the result should be stored there. For example, the user inputs the table row
value along with the input ; then for each row in the table to be generated,
have a command that accomplishes the following:
if(table row is me, then put the input and result here, else don’t do
anything)
A1 has a user input. B1 = 3*A1. I want to create a table as follows
Input Result
2 6
3 9
-4 -12
I suspect you can use one of the pointer functions to tell Excel where to
store the next result, but I can’t figure out how to do that – is there
something equivalent to a STORE command.
Another thought is to have the table cells check the user input to see if
the result should be stored there. For example, the user inputs the table row
value along with the input ; then for each row in the table to be generated,
have a command that accomplishes the following:
if(table row is me, then put the input and result here, else don’t do
anything)