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....
Relative cell references are handled by using Function parameters
https://docs.google.com/spreadsheets/d/1wzBC1D58q585tX5GYLO_BIS8LSSc22h5DcPFnKZ2fp0/edit?usp=sharing