[libreoffice-users] Finding address of cell with minimum value in an array

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: users+unsubscribe@global.libreoffice.org
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