[libreoffice-users] Re: HELP WITH CODE excel

Am 08.08.2011 14:08, Andrew Douglas Pitonyak wrote:
> > > =INDIRECT(CELL("ADDRESS",INDEX($P$28933:$P$29998,MATCH(MIN(Q28931:Q29998),Q28931:Q29998,))))
> > >
> > > The help would be greatly appreicated
> > > --

How can INDIRECT(CELL(ADDRESS;INDEX(...)))
return anything else than INDEX(...) alone?
If I recall correctly, this was an ugly hack for an Excel restriction 
where cell validation by range failed when the validation list was on 
another sheet. This hack is not required in OOo.
Apart from this, the above formula should simply work when you import 
the xls file. The office takes care of this.
Since this is LibreOffice, the comma should be just fine if it used to 
be just fine in Excel. But nobody can really tell for sure. I wish the 
devs would restore the clear formula syntax as in OOo.

The last argument of MATCH is missing which is not intended in most 
cases. If it is intended, the comma should be left out as well.


--
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