Generating a Table of Results
 

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.

Generating a Table of Results
 

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.

Generating a Table of Results
 

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.

Generating a Table of Results
 

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.

Generating a Table of Results
 

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.