LibreOffice Calc min funcktion

[elena1]

So in Libreoffice calc I need to use min function, but it should show the cell above it not the number. I couldn't figure it out, can somebody help?

[FJCC]

If you want the cell address of the minimum value in the range A1:A10, you can use

Code: Select all

=ADDRESS(MATCH(MIN(A1:A10);A1:A10;0);1;1)

If the cell range you want to search does not start in row 1, you will have to add the appropriate offset to the result of the MATCH() function.