After posting my query on this message board (I needed to show the last entered value in any given column in a cell at the top of the sheet), I was given the following formula:
=INDEX(F:F,MATCH(9.99999999999999E+307,F:F))
where "F" is the column in which I am looking for the information. Well, this formula is great except that it does not work on some of my files. I have looked for patterns but have found none. It is not because of an old file format because it does not work on some files created under a month ago.
I need either a fix to make it work on all sheets or a new formula that doesn't have this problem. Help please!
=INDEX(F:F,MATCH(9.99999999999999E+307,F:F))
where "F" is the column in which I am looking for the information. Well, this formula is great except that it does not work on some of my files. I have looked for patterns but have found none. It is not because of an old file format because it does not work on some files created under a month ago.
I need either a fix to make it work on all sheets or a new formula that doesn't have this problem. Help please!