https://bugs.freedesktop.org/show_bug.cgi?id=83131
--- Comment #3 from Robert Pollak <[email protected]> --- Additionally, there should be COLMAX,COLMIN for the number of the maximal/minimal column. I just see that my description is inconsistent: It should be ROWMAX, not ARGMAX. Actually, maybe ARGMAX is even better than ROWMAX/COLMAX: It could return the cell reference of the maximal/minimal value. In my use case, the year with maximal income would then be "=OFFSET(ARGMAX(<income column>), 0, -1)". Hmm - I just found out that the whole functionality is partially covered by HLOOKUP/VLOOKUP. In my use case, the "income" column would need to be left of the "year" column, then the year with maximal income is "=VLOOKUP(MAX(<income column>), <table region>, 2, FALSE)". -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
