Cell A1 has a constant. Cell B1 has a result derived from the rest of the
spreadsheet. How can I generate a table of results somewhere in the sheet,
after changing the contents of cell A1 a number of times.? I would prefer not
to use VBA or a pivot table.

Input (from A1) Result (from B1)
Input 1 Result 1
Input 2 Result 2
Etc .

Does Excel have something equivalent to a Store Function. If I input the
data in A1 and a row number in A2, say. then what I want to do is equivalent
to the following:

STORE(A1) in Col.D, Row (A2) and Store(B1) in Col. E, Row (A2),

where (X) is the contents of cell X.

Look at DataTable

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"bikerhal" wrote in message
...
Cell A1 has a constant. Cell B1 has a result derived from the rest of the
spreadsheet. How can I generate a table of results somewhere in the sheet,
after changing the contents of cell A1 a number of times.? I would prefer
not
to use VBA or a pivot table.

Input (from A1) Result (from B1)
Input 1 Result 1
Input 2 Result 2
Etc .

Does Excel have something equivalent to a Store Function. If I input the
data in A1 and a row number in A2, say. then what I want to do is
equivalent
to the following:

STORE(A1) in Col.D, Row (A2) and Store(B1) in Col. E, Row (A2),

where (X) is the contents of cell X.

Use Data Table????

The data table, as I understand it, generates results for a given set of
inputs based on a formula that is "part" of the data table But, I want to
input a number and have a complex spreadsheet generate the result. What is in
cell B1 is that result which I want tabled along with the input.

I don't see how Data Table does this. Can you provide an example?

"bikerhal" wrote:

Cell A1 has a constant. Cell B1 has a result derived from the rest of the
spreadsheet. How can I generate a table of results somewhere in the sheet,
after changing the contents of cell A1 a number of times.? I would prefer not
to use VBA or a pivot table.

Input (from A1) Result (from B1)
Input 1 Result 1
Input 2 Result 2
Etc .

Does Excel have something equivalent to a Store Function. If I input the
data in A1 and a row number in A2, say. then what I want to do is equivalent
to the following:

STORE(A1) in Col.D, Row (A2) and Store(B1) in Col. E, Row (A2),

where (X) is the contents of cell X.

There are examples in HELP. DataTable (from the main menu) does exactly
what you require.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"bikerhal" wrote in message
...
Use Data Table????

The data table, as I understand it, generates results for a given set of
inputs based on a formula that is "part" of the data table But, I want to
input a number and have a complex spreadsheet generate the result. What is
in
cell B1 is that result which I want tabled along with the input.

I don't see how Data Table does this. Can you provide an example?

"bikerhal" wrote:

Cell A1 has a constant. Cell B1 has a result derived from the rest of the
spreadsheet. How can I generate a table of results somewhere in the
sheet,
after changing the contents of cell A1 a number of times.? I would prefer
not
to use VBA or a pivot table.

Input (from A1) Result (from B1)
Input 1 Result 1
Input 2 Result 2
Etc .

Does Excel have something equivalent to a Store Function. If I input the
data in A1 and a row number in A2, say. then what I want to do is
equivalent
to the following:

STORE(A1) in Col.D, Row (A2) and Store(B1) in Col. E, Row (A2),

where (X) is the contents of cell X.

Got it - thanks.

"Niek Otten" wrote:

There are examples in HELP. DataTable (from the main menu) does exactly
what you require.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"bikerhal" wrote in message
...
Use Data Table????

The data table, as I understand it, generates results for a given set of
inputs based on a formula that is "part" of the data table But, I want to
input a number and have a complex spreadsheet generate the result. What is
in
cell B1 is that result which I want tabled along with the input.

I don't see how Data Table does this. Can you provide an example?

"bikerhal" wrote:

Cell A1 has a constant. Cell B1 has a result derived from the rest of the
spreadsheet. How can I generate a table of results somewhere in the
sheet,
after changing the contents of cell A1 a number of times.? I would prefer
not
to use VBA or a pivot table.

Input (from A1) Result (from B1)
Input 1 Result 1
Input 2 Result 2
Etc .

Does Excel have something equivalent to a Store Function. If I input the
data in A1 and a row number in A2, say. then what I want to do is
equivalent
to the following:

STORE(A1) in Col.D, Row (A2) and Store(B1) in Col. E, Row (A2),

where (X) is the contents of cell X.