Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Dynamic Formula
If in Column A there is data and Column B carries out a calculation on Column
A and displays the result, how do I get Column B to automatically update when I enter data into Column A? Thanks in advance Alan |
#2
|
|||
|
|||
On Sun, 29 May 2005 05:04:02 -0700, awwtau
wrote: If in Column A there is data and Column B carries out a calculation on Column A and displays the result, how do I get Column B to automatically update when I enter data into Column A? Thanks in advance Alan Tools/Options/Calculation Calculation: Automatic --ron |
#3
|
|||
|
|||
Can you have the whole of Column B set with a formula that automatically
updates given the value of Column A? I know you can click the bottom right of a cell and that carries the formula onto the next row but I don't want to have to do this with every row, so it would be good if the entire column was set with the formula? "Ron Rosenfeld" wrote: On Sun, 29 May 2005 05:04:02 -0700, awwtau wrote: If in Column A there is data and Column B carries out a calculation on Column A and displays the result, how do I get Column B to automatically update when I enter data into Column A? Thanks in advance Alan Tools/Options/Calculation Calculation: Automatic --ron |
#4
|
|||
|
|||
If data already exists in Column A, then a *double* click on the "fill
handle" of the formula cell in Column B will copy the formula down Column B, as far as there is data in Column A. If there is no data in Column A, then you must click *and drag* the "fill handle" of the formula cell down Column B as far as needed. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "awwtau" wrote in message ... Can you have the whole of Column B set with a formula that automatically updates given the value of Column A? I know you can click the bottom right of a cell and that carries the formula onto the next row but I don't want to have to do this with every row, so it would be good if the entire column was set with the formula? "Ron Rosenfeld" wrote: On Sun, 29 May 2005 05:04:02 -0700, awwtau wrote: If in Column A there is data and Column B carries out a calculation on Column A and displays the result, how do I get Column B to automatically update when I enter data into Column A? Thanks in advance Alan Tools/Options/Calculation Calculation: Automatic --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Frequency formula | Excel Worksheet Functions | |||
Multiple Condition Sumif Formula | Excel Worksheet Functions | |||
Dynamic chart | Excel Discussion (Misc queries) | |||
Indirect and dynamic ranges | Excel Worksheet Functions | |||
Cell shows formula and not the result of the formula. | Excel Worksheet Functions |