I'm looking for some help in defining the formula to locate the address of the
cell with the minimum value in an array in a Calc spreadsheet.
I've been using this formula to return the address of the cell with the maximum
value in the array B6:U17
=ADDRESS(MAX((B6:U17=MAX(B6:U17))*ROW(B6:U17)),
MAX((B6:U17=MAX(B6:U17))*COLUMN(B6:U17)))
Saved of course as an array formula using Shift+Ctrl+return which wraps it in
{}.
This has worked well for a long time. Now I wish to locate the address of the
cell with the minimum value. My simple logic thought that changing MAX for MIN
in the above formula would give me the result but it produces an ERR 502
(Invalid argument) which I don't understand.
Can someone correct me here, please?
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--
To unsubscribe e-mail to: [email protected]
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy
