= COUNTA function has no empty cells in a range
To serve:
In this form the user enters new rows (and data) every day. As a lot of data and every now and need to go to the end of the return, = COUNTA returns the number of the last row loaded and avoids having to scroll down to.
(click to enlarge) Click on the image, the formula = COUNTA (A: A) indicates that the last figure is in line 536.
To go to cell F5 press.
0 comments:
Post a Comment