I would like to write a formula which returns the size of an array. something like
size(A1:A50)Maybe, it seems to be strange; but it helps me when I insert some new rows in the first 50 lines and my formula updates automatically; but if I wrote 50 instead of (let say) size(A1:A50), it would not update automatically and it makes problem for me.
1 Answer
The simplest answer is the ROWS function: ROWS(A1:A50) is 50.
