In this tip, We are going to explore:
How to find the last row dynamically?
All explanations are simple and to the point.


#Shorts #GoogleForEducation #GoogleWorkspace #GoogleSheets

If you found this video helpful, give us an old like and share it with some people you think this could be helpful for. And if you're not already a subscriber, make sure to hit the subscribe button and also the notification bell to be notified every time a video is uploaded

Useful Link:
Google Workspace Tutorial:
[ Ссылка ]

Ben Collins (Google Developer Expert & Data Analytics Instructor)
[ Ссылка ]

Google Sheets training:
[ Ссылка ]

The Playlist link:
[ Ссылка ]

Follow us on Pinterest:
[ Ссылка ]


This data is updated daily.
How to find the last row dynamically?
We could use the Double INDEX to find it.
Type this formula:
ArrayFormula(A:A)
It returns the values of column A.
We get the same result using the double INDEX.
INDEX(A:A):INDEX(A:A)
To find out the number of the rows, we use the COUNTA function.
INDEX(A:A,COUNTA(A:A)):INDEX(A:A,COUNTA(A:A))
Using this formula, we get the value of the last row dynamically.

свернуть