On 08/07/2011 12:00 AM, nvrk wrote:
On Sat, Aug 6, 2011 at 8:13 PM, Joseph Da Silva<[email protected]
wrote:



Hi

I was wondering if someone could help me with this code it works in excel
but not with libra office.

=INDIRECT(CELL("ADDRESS",INDEX($P$28933:$P$29998,MATCH(MIN(Q28931:Q29998),Q28931:Q29998,))))
The help would be greatly appreicated
--

Wondering - what is purpose of the comma just to the left of the 4 close
parentheses?
nvsoar


Besides the "extra" comma (good catch nvsoar), must the commas "," be changed to 
semicolons ";"?


--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
Info:  http://www.pitonyak.org/oo.php


--
For unsubscribe instructions e-mail to: [email protected]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Reply via email to