Re: Issue with code

Hi Eike,
 
Thank you for your response I have tried your suggestions and have provided a sample file with the formula.
 
If you have a chance take a look.
 
Thanks
 

 
> Date: Mon, 8 Aug 2011 22:42:26 +0200
> From: [email protected]
> To: [email protected]
> CC: [email protected]
> Subject: Re: [discuss] Re: Issue with code
> 
> Hi Joseph,
> 
> On Sunday, 2011-08-07 21:06:57 +0000, Joseph Da Silva wrote:
> 
> >  =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
> 
> Err:508 is an "errPairExpected" and probably due to the extraneous
> parenthesis in the expression at the end you had in your previous mail,
> not in this one, try to remove that.
> 
> Other than that, in OOo the parameter separator is a ; semicolon, not
> a comma, unless you use a go-oo / LibreOffice that comes with your Linux
> distribution. Check under Tools->Options->Calc->Formula if there are
> separator settings.
> 
>   Eike
> 
> -- 
>  PGP/OpenPGP/GnuPG encrypted mail preferred in all private communication.
>  Key ID: 0x293C05FD - 997A 4C60 CE41 0149 0DB3  9E96 2F1A D073 293C 05FD