Is there a way of fill a formula down to the last row dynamically as new lines are added without a script just in the formula in google sheets I need the formula only in the cells with data and not in empty cells so if I have in column B1/B5 1,2,3,4,5 I want in column A1 =B1 and to fill down to row A5 =B5, and only in the first 5 rows and to automatically add the formula in A6 when B6 is filled.
Aucun commentaire:
Enregistrer un commentaire