What about MINA?
On Thursday 02 January 2025 10:13:57 AM (-06:00), Philip Jackson wrote:
> 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?
>
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--
--
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005
--
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
