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
pgpRgfLF26MLu.pgp
Description: PGP signature
