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
FORUMLA TEST.ods
Description: application/vnd.oasis.opendocument.spreadsheet
