Generating a Table of Results

[bikerhal]

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.

 

[Niek Otten]

Look at Data>Table

 

[bikerhal]

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?

 

[Niek Otten]

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

 

[balhal]

Got it - thanks.

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel