Hi ,



I'd like to know if it's possible to propagate a formula which references a named cell but having the formula change reference cells accordingly when propagated.

Say for example I had cell A1 named OmegaT and in cell B1 I had =OmegaT+180 then I propagated the equation down column B. It seems that OmegaT is treated as $A$1. Is it possible to make the equation in cell B# reference A# rather than being locked to A1?

Thanks

What do you mean?

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

The spreadsheet should make the question a little clearer.

Attached Files

OmegaT.xlsx (9.6 KB, 13 views)

Go to the Name Manager ( formula ribbon), select the name and remove the $ sign from the row reference in the "refer to" field

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Thanks, that's exactly what I was looking for.