Is there a way to permanently capture a formula generated value prior to it changing again via the formula?
Example: If my cell formula is A1+B1=4; I want to, prior to it being changed via the formula, permanently preserve the value “4” (in another cell and not subject to change by the original formula).
—–
Ted
You can set that other cell to mimic the first one. So if that formula is in C1, then in D1 you can put =C1. So now D1 shows what C1 has.
Then, select D1. Edit, Copy. Then with D1 still selected choose Edit, Paste Formula Results.
I’m aware of your suggested solution. I don’t want the user to have to do this edit. Also, I need the “preserved value” in another formula. Am I asking for a Numbers impossible?
Thks Gary for response . . . any other suggestion?
To put it more simply, I’m trying to accomplish exactly what you suggested . . . but do it via a formula or function. Not by keyboard entry.
Thks again.
Ted: There's no way to do that via a formula. Spreadsheets don't work that way. Formulas are "live" and don't know on their own when to switch from a formula to a number.
So maybe if I knew WHY you wanted to do this I could make a suggestion. You kinda skipped that part of the question, just restating the question as an example.
I have the same question, and my reasoning is that I'd like to delete certain rows based on a criteria.
I have a function which prints "DUP" based on certain criteria. If the output of the function was permanent, I could then sort the column and remove all rows containing "DUP" which are grouped. However, since the function is based on a relationship between the rows (i.e. a duplicate entry, determined by comparing row values), sorting the data changes which row is identified a duplicate.
Mina: so did my initial response above solve the problem for you?