-1

I thought I was onto an excellent way to re-use cell formulas - but came up against the named function editor being determined to mangle anything I entered into absolute cell references - so I couldn't drag cells containing my named formula and have it use relative references internally

eg., $C2 became $C$2 so all rows referred to the same data on the same row

do I need to mangle things and treat my formula as text, somehow find the row or range in which the formula is being called and dig out the row etc etc

disappointing after an hour or so....

badcop666
  • 121
  • 2
  • 9
  • It's not clear what are you asking. If you want some help, probably there's a workaround, but we need more information (formula, context, desired results) – Martín Feb 01 '23 at 03:04
  • It would be better if you could provide a sample sheet with test data, where the community can replicate the issue to fully grasp what you are experiencing. See [How to create a Minimal, Reproducible Example](https://stackoverflow.com/help/minimal-reproducible-example). – SputnikDrunk2 Feb 01 '23 at 03:43

1 Answers1

0

Relative cell references are handled by using Function parameters

https://docs.google.com/spreadsheets/d/1wzBC1D58q585tX5GYLO_BIS8LSSc22h5DcPFnKZ2fp0/edit?usp=sharing

badcop666
  • 121
  • 2
  • 9