Timeline for Numbers function that returns the location for the current cell
Current License: CC BY-SA 4.0
9 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Mar 11, 2019 at 13:10 | comment | added | jetset | The ROW() and COLUMN() functions evaluate to the current cell's row and column, so you can use those in other functions such as OFFSET in order to create a formula that is immune to being copied and pasted. | |
| Jan 11, 2019 at 14:25 | comment | added | pedz | The alternative (I think, please tell me if I'm wrong) will be to just put something like A1 in place of all the 30 instances and then paste the formula into A2. Then, when I copy (from Numbers) and paste again to, lets say, cell B99, the A1 reference will get changed to B98. I'll try that over the weekend... time for work :-) ... Oh! and then I could probably "move" B98 (which would be one row up) to A99 and Numbers would update all the references in the formula. | |
| Jan 11, 2019 at 2:46 | comment | added | SilverWolf | Ah, I see what you mean. (: It looks like you should do the reference click as your last step -- when you copy it from the formula box, it doesn't update the references, and when you copy the cell without the box open, it will copy the result outside of Numbers (as rich text) but inside Numbers it must be maintaining a separate buffer with formula information. When you paste it elsewhere, it will paste the formula, moving all the references as well. | |
| Jan 11, 2019 at 2:27 | history | edited | pedz | CC BY-SA 4.0 |
Supplied the full example of what I'm trying to do and why
|
| Jan 11, 2019 at 2:01 | comment | added | pedz | Lets try this again. I'm creating the equation outside of Numbers in an editor called Emacs. "clicking" in Numbers while I'm composing the equation in Emacs isn't going to do anything. | |
| Jan 10, 2019 at 21:16 | comment | added | SilverWolf | What do you mean "paste it, fix it, copy it"? It should Just Work™ if you copy and paste the formula without even modifying it. Or is that what you're doing, and I'm missing something? | |
| Jan 10, 2019 at 21:10 | comment | added | pedz | Ah.. I see. Paste the equation, fix it, then copy and paste the result to the other locations. I'll try and make that work. | |
| Jan 10, 2019 at 17:00 | comment | added | SilverWolf | Try just clicking on the cell, creating a reference? Since references are relative by default, it should still work if you paste/fill the cell to elsewhere. | |
| Jan 10, 2019 at 14:50 | history | asked | pedz | CC BY-SA 4.0 |