Hi, I have a range (G3:Z3) where the cells will always be filled starting from column G. I have been able to get the last completed cell in range using;
=INDEX(G3:Z3,MATCH(9.99999999999999E+307,G3:Z3))
what I'm looking for is the 2nd last, 3rd last completed cell in the range.
Is this...