I want to create a formula where I take the newest value on a cell. The information is updated when someone fills out the Google Form. Basically, there is some information the customer might not fill out, so the information is sparse.
What I want to create is a formula where it always takes the very bottom value of the spreadsheet (newest information). Even if the cell was blank, I want it to output as blank, and if there is an information on that cell, output it as that written value. Is this possible using INDEX and IF formula? Or is there some other formula to solve this problem.
If this doesn't make sense, please comment and I'll answer.
=INDEX(A:A, COUNTA(A:A))
Aucun commentaire:
Enregistrer un commentaire