Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Createing a self-sustaining column?
Here is what I want to do... I need to build a database
of a few 100 inputs. But all I want to do is put in one input. For instance, each row has five columns. I put in the first column and the other four can be calculating using just the first column. For the second row I want it to take the value of the last column of the row prior. So on so on. So row 60 column 1 would take the value of row 59 column 5... Is there a way to set it up so that all I need to do is put in the first value, row 1 column 1. And excel will calculate all of the values straight through? For instance my columns are like this... C1 C2 C3 C4 5 .5 2.5 7.5 7.5 .5 3.75 11.25 11.25 .5 ......... Thanks |
#2
|
|||
|
|||
Assuming A1 to E1000
In A2, add =IF(E1<"",E1,"") Copy B1:E1 to B2:E2 Copy A2:E2 down to A1000:E1000 -- HTH RP (remove nothere from the email address if mailing direct) "Mike" wrote in message ... Here is what I want to do... I need to build a database of a few 100 inputs. But all I want to do is put in one input. For instance, each row has five columns. I put in the first column and the other four can be calculating using just the first column. For the second row I want it to take the value of the last column of the row prior. So on so on. So row 60 column 1 would take the value of row 59 column 5... Is there a way to set it up so that all I need to do is put in the first value, row 1 column 1. And excel will calculate all of the values straight through? For instance my columns are like this... C1 C2 C3 C4 5 .5 2.5 7.5 7.5 .5 3.75 11.25 11.25 .5 ......... Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
what formula do i put for column m = column k minus column l in e. | Excel Discussion (Misc queries) | |||
how to fit my column unmoved eventhough i scroll down? | New Users to Excel | |||
Can you average data in 1 column based on a range of values in another? | Excel Worksheet Functions | |||
Copying the contents of a column into a chart | Excel Worksheet Functions | |||
How to calculate the data in excel 2002 including only the last 9. | Excel Worksheet Functions |