Posts by nioc98

    Problem:
    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?