I am using the formula =INDEX(G3:G12,COUNTA(G3:G12)) to extract the last number from a column of numbers.
It will only work when all 10 cells in the column are filled.
However, I need it to work no matter how many cells are filled. The cells G3:G12 contain formulas of the type: =IF(B5="","",G4).
Why will it not work? How do I make it work?
Please note that on 14th December 2023 users will experience an expected outage whilst we make upgrades to our network. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.