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.

That formula works just fine.

Do the formulas return 0s and you have 0 display turned off?

A shorter version of that formula:

=LOOKUP(10^10,A:A)

Even better to use a constant for the lookup_value:

=LOOKUP(1E10,A:A)

--
Biff
Microsoft Excel MVP


"rdp" wrote in message
...
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.