|
PureBytes Links
Trading Reference Links
|
There was a syntax error. Try this:
=INDEX(A:A;MATCH(9.99999999999999E+307;A:A))
I've tried it and it works.
Regards,
mc
--- In equismetastock@xxxxxxxxxxxxxxx, jao yan <jaoyan100@xxx> wrote:
>
> MC, thanks, but the formula does not work
> jao...
>
>
>
>
> ________________________________
> From: p_panther_73 <mchantzi@xxx>
> To: equismetastock@xxxxxxxxxxxxxxx
> Sent: Monday, February 2, 2009 3:04:16 AM
> Subject: [EquisMetaStock Group] Re: Last value in coloumn
>
>
> 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@ ..> 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!
> >
>
------------------------------------
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/
|