Hi
Thanks for the quick reply
=INDIRECT(CELL("ADDRESS",INDEX($P$28933:$P$30000,MATCH(MAX(Q28933:Q30000),Q28933:Q30000,0))))
The issue is I am getting a 508 with version 3.30 error but works fine with
Microsoft Excel
Thanks
> Date: Sun, 7 Aug 2011 22:03:15 +0200
> From: [email protected]
> To: [email protected]
> CC: [email protected]
> Subject: Re: [discuss] Issue with code
>
> Hi Joseph,
>
> On Wednesday, 2011-08-03 02:10:43 +0000, Joseph Da Silva wrote:
>
> > Here is the code I am having an issue with in open org works in excel
> >
> > =INDIRECT(CELL("ADDRESS",INDEX($P$28933:$P$30000,MATCH(MAX(Q28933:Q30000),Q28933:Q30000,0)))))
> > There seems there is an issue with the CELL command and using 3.30
> > version on windows 7 Any advise would be appreciated. Thanks for your
> > time and consideration
>
> And the issue is?
>
> Eike
>
> P.S.: As you're not subscribed to the mailing list you were posting to,
> you will miss replies that are directed to the list only. When answering,
> please reply only to the list (Reply-To header is set), not to my
> personal account. Thanks.
>
> --
> PGP/OpenPGP/GnuPG encrypted mail preferred in all private communication.
> Key ID: 0x293C05FD - 997A 4C60 CE41 0149 0DB3 9E96 2F1A D073 293C 05FD
--
-----------------------------------------------------------------
To unsubscribe send email to [email protected]
For additional commands send email to [email protected]
with Subject: help
