How to Get the Array Size in Ms Excel?

How to Get the Array Size in Ms Excel?

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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Robert Thorne
Author

Robert Thorne

Robert Thorne covers electric vehicle innovations, autonomous driving systems, global mobility trends, and automotive engineering developments.