Similar answer to caligari’s answer, but we can tidy it up by just specifying the full column range:
=INDEX(G2:G, COUNT(G2:G))
Similar answer to caligari’s answer, but we can tidy it up by just specifying the full column range:
=INDEX(G2:G, COUNT(G2:G))