I am trying to make data from the last used cell in a column appear in
another cell at the top of the same column. Another user gave me the formula
=INDEX(A:A,MATCH(10^10,A:A)) and this works fine unless the cells in the
column have formulas in them, in which case the result is a blank cell.

Thank you.