Link to last entry

Thanks for clearing that up. I pasted it from the Google link and it
works fine now. Just a tip if anyone else reads this - when I pasted
it in, it didn't seem to want to be entered as an array formula, so I
just deleted one of the brackets and replaced it, then pressed ctrl
-shift-enter and it worked.

Thanks again.


Max Wrote:
> Believe the site/place where you're posting to or reading posts from
> unfortunately removes all the "greater than", "less than" or "not equal
> to"
> symbols from posts, including from within formulas, that's the trouble
> ..
>
> .... MAX((A1:A65535"") ...
>
> There's a missing "not equal to" sign between the
> A65535 and the double quotes "" in the above part
>
> Just insert the missing piece in the formula, and it'll work fine ..
>
> You could also try also viewing, and copy and paste JE's formula
> direct from this google link: http://tinyurl.com/8gysf
> --
> Rgds
> Max
> xl 97
> ---
> GMT+8, 1° 22' N 103° 45' E
> xdemechanik atyahoodotcom
> ----


--
dthomas

You're welcome !
Glad to hear you got it up.
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----
"dthomas" <[email protected]> wrote in message
news:[email protected]...
>
> Thanks for clearing that up. I pasted it from the Google link and it
> works fine now. Just a tip if anyone else reads this - when I pasted
> it in, it didn't seem to want to be entered as an array formula, so I
> just deleted one of the brackets and replaced it, then pressed ctrl
> -shift-enter and it worked.
>
> Thanks again.