Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
N0 112.1115
a 478.5722 tau 29.0452 sigma 17.25609 deltasq 304.968 I have the following list of variables, the first 4 are input by hand and deltasq is worked out from them using solver and a bit of vis basic. I would like to be able to input a list of numbers into one of the variables and output each corresponding deltasq. I'm afraid my programming isnt up to much so excuse this vague hand waving attempt to clarify what i would like it to do For n=0 counter 100 Insert A1+n into N0 Output deltasq into B1+n Where there would be list of a hundred numbers in column A. Cheers for any help otherwise i'm going to have to manually enter hundreds of numbers as i need to repeat this many times. Thank you Peter |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Inserting rows using a list of numbers | Excel Discussion (Misc queries) | |||
Retrieving last actual value in a list | Excel Discussion (Misc queries) | |||
Ooh .. Linking a list to a list to an output cell | Excel Discussion (Misc queries) | |||
Retrieving list of worksheets programmatically | Excel Programming | |||
Retrieving data from a database list | Excel Discussion (Misc queries) |