Finding last value in array?

I think the thread says it all . Basically, the data in an array changes when I change the settings of the numbers I input, so the final value constantly changes. I need a way to "find" the last value in the array and display it in a cell, is there a way of doing this using a function, or otherwise?

Cheers Dr.K.

Lets assume the data is in column A, use this formula:

=OFFSET($A$1,COUNTA(A:A),0)

Let me know if that works.

Originally Posted by starguy

Try this as well

=LOOKUP(2,1/(A1:A100<>""),A1:A100)

Fantastic, worked a treat. I knew it was something like this but couldn't figure it out. Cheers for your reply BigBas too.

Originally Posted by starguy

Try this as well

=LOOKUP(2,1/(A1:A100<>""),A1:A100)

Can you please explain exactly how this formula works? It works beautifully but I can't wrap my head around the arguments.