INDEX | dynamic range - finding the last row
INDEX | dynamic range - finding the last row.
To find the last row dynamically, we use the COUNT function for the row index.
The COUNT range is open-ended.
The INDEX range is open-ended too.
Now, by adding a new row, we get its value.
