In Numbers, is there a way to get the row instead of the value when using a MAX or MIN Function?

Solution 1:

Using INDEX(MATCH) this can be easily accomplished.

Formulas

This formula returns the food label:
=INDEX(Foods, MATCH(MIN(Cost),Cost))

• The INDEX function returns the value in the cell located at the intersection of the specified row and column within a collection of cells or from an array returned by an array function.
• The MATCH function returns the position of a value within a collection.

This formula returns the Row number:
=ROW(INDEX(Foods,MATCH(MIN(Cost),Cost)))

• The ROW function returns the row number of the row containing a specified cell.

Replacing MIN with MAX returns the row with the Max result.

Further information on these functions can be found in the Functions reference.

ROW

The ROW function returns the row number of the row containing a specified cell.

ROW(cell)
• cell: An optional cell reference to a single table cell. The referenced cell that can contain any value, or be empty. If cell is omitted, as in =ROW(), the function returns the row number of the cell that contains the formula.

Examples
=ROW(B7) returns 7, the number of row 7.

=ROW() returns the absolute row number of the cell containing the function