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