Re: [libreoffice-users] HELP WITH CODE excel

On 08/07/2011 12:00 AM, nvrk wrote:
> On Sat, Aug 6, 2011 at 8:13 PM, Joseph Da Silva<joseph_da_silva@hotmail.com
> > 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: users+help@global.libreoffice.org
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