Home |
Search |
Today's Posts |
#1
|
|||
|
|||
need to save values from a function before it changes
I have a list of functions calculating values down a column as the rows
increase. I must have the previous function clear when the next function produces a value. The vaue calculated from the function is save in the next column. When the previous function clears == the value clears with it. However, I need those values. How can I lock and save those values ? Can someone help please. Thank you. Using Excel 2003. |
#2
|
|||
|
|||
Hi
not possible without using VBA -- Regards Frank Kabel Frankfurt, Germany "Ron" schrieb im Newsbeitrag ... I have a list of functions calculating values down a column as the rows increase. I must have the previous function clear when the next function produces a value. The vaue calculated from the function is save in the next column. When the previous function clears == the value clears with it. However, I need those values. How can I lock and save those values ? Can someone help please. Thank you. Using Excel 2003. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Second serie doesn't use X-as values | Charts and Charting in Excel | |||
LOOKUP FUNCTION WITH SUMS VALUES | Excel Discussion (Misc queries) | |||
Save External Link Values | Excel Discussion (Misc queries) | |||
Save & Save As features in file menu of Excel | Excel Discussion (Misc queries) | |||
Missing "Save" and "Save As" functions | Excel Discussion (Misc queries) |