[pc86]

Not exactly a fix to what you're referring to, but if the data is formatted as a table the formula is copied to every cell automatically.

[ForEnglandJames]

Have used exactly this feature in a freelancing gig to help contain data entry/formula copying errors.

I just wish it were less obtuse to set up.