Found this one (haven't tried it but guess it works):
=INDEX(A:A,MATCH( 9.99999999999999 E+307,A:A) )
Regards,
mc
--- In equismetastock@ yahoogroups. com, jao yan <jaoyan100@x ..> wrote:
>
> hi Douglas, please refer to the attached file, it will clearly
explain my request.
> thanks for help
> jao...
>
>
>
>
> ____________ _________ _________ __
> From: Douglas H Kallevig <douglaskallevig@ ...>
> To: equismetastock@ yahoogroups. com
> Sent: Saturday, January 31, 2009 8:55:22 PM
> Subject: Re: [EquisMetaStock Group] Last value in coloumn
>
>
>
>
> Hi jao,
>
> In excel, in cell A8, put an ( = ) sign.
> As soon as you do this, a little icon fx will appear along with the
equal (=) sign next to it.
>
> Click on the fx, find the MAX (maximum) function , click on MAX,
Next,and then Finish
>
> With any luck your formula in Cell A8 wil be:
>
> =MAX(A1:A7)
>
> This will give you the maximum number in cells A1 through A7.
>
>
>
> How is the weather in your part of the world. It is cold here.
>
> Doug
>
>
> hi, Douglas
> tried to open the file, but it does not, in what program it should open!
> thanks
> jao...
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> ____________ _________
_________ _________ _________ _________ ___
> Carry that weight with a comfortable new backpack. Click now!
>