|
PureBytes Links
Trading Reference Links
|
Found this one (haven't tried it but guess it works):
=INDEX(A:A,MATCH(9.99999999999999E+307,A:A))
Regards,
mc
--- In equismetastock@xxxxxxxxxxxxxxx, jao yan <jaoyan100@xxx> wrote:
>
> hi Douglas, please refer to the attached file, it will clearly
explain my request.
> thanks for help
> jao...
>
>
>
>
> ________________________________
> From: Douglas H Kallevig <douglaskallevig@xxx>
> To: equismetastock@xxxxxxxxxxxxxxx
> 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!
>
------------------------------------
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/equismetastock/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/equismetastock/join
(Yahoo! ID required)
<*> To change settings via email:
mailto:equismetastock-digest@xxxxxxxxxxxxxxx
mailto:equismetastock-fullfeatured@xxxxxxxxxxxxxxx
<*> To unsubscribe from this group, send an email to:
equismetastock-unsubscribe@xxxxxxxxxxxxxxx
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
|