Referencing cells with formulas results in blank cell.
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. |
Referencing cells with formulas results in blank cell.
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. |
All times are GMT +1. The time now is 01:32 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com