Last cell data

[@Homeonthecouch]

Hello,

I have a series of cells lets say A1 to A10
In each cell is the formula
=IF($B427<=$J$14,D426+F427+G427,"")
=IF($B428<=$J$14,D427+F428+G428,"")
And so forth

I am wanting the last value to be displayed in cell H10, lets say.
So if A1, A2, A3 and A4 have data but A5 onwards have no data How do I report the last value (A4) in another cell?

Hope that makes a little sense to someone.

Any help is appreciated.

Andrew

 

[@Homeonthecouch]

Found it on google...... @ http://www.techonthenet.com/excel/questions/last_value.php


=INDEX(A1:A10,MATCH(REPT("z",255),A2:A10))



Just thought I would post this in case someone else finds it useful.



Andrew



Hello,

I have a series of cells lets say A1 to A10
In each cell is the formula
=IF($B427<=$J$14,D426+F427+G427,"")
=IF($B428<=$J$14,D427+F428+G428,"")
And so forth

I am wanting the last value to be displayed in cell H10, lets say.
So if A1, A2, A3 and A4 have data but A5 onwards have no data How do I report the last value (A4) in another cell?

Hope that makes a little sense to someone.

Any help is appreciated.

Andrew

 

[Gord Dibben]

That formula will fail if the data is numeric so not really useful with your
sample data.

=LOOKUP(99^99,A:A) for numeric data.

=LOOKUP(2,1/(A1:A65535<>""),A1:A65535) any value, number or text


Gord Dibben MS Excel MVP

 

[T. Valko]

Try this:

=LOOKUP(1E100,A1:A10)