Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change data, record output
I would like to enter a column of numbers into a cell in a spreadsheet and
record the output value of the spreadsheet each time. I tried to do a data table but the result of the data table was zero each time. Is a data table not the right way to do this? I could use scenarios and create a scenario summary to get the information but I have a few hundred data points I would like to enter which would result in a few hundred scenarios. What is the best way to accomplish this? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change data, record output
.. I tried to do a data table
but the result of the data table was zero each time. Perhaps you might want to try this illustrative sample from my archives to get a quick grasp of the Data Table functionality: http://savefile.com/files/46276 2 variable data table example.xls -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Brian Hahn" wrote: I would like to enter a column of numbers into a cell in a spreadsheet and record the output value of the spreadsheet each time. I tried to do a data table but the result of the data table was zero each time. Is a data table not the right way to do this? I could use scenarios and create a scenario summary to get the information but I have a few hundred data points I would like to enter which would result in a few hundred scenarios. What is the best way to accomplish this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying cell values to a external file in VBA | Excel Discussion (Misc queries) | |||
macro | Excel Discussion (Misc queries) | |||
ranking query | Excel Discussion (Misc queries) | |||
Remove Data Format Change | Excel Discussion (Misc queries) | |||
Record data on two lines | Excel Discussion (Misc queries) |