Max function with cell lookup

[Scott]

I need to determine the row or column of the result of a
another function.
In my case I am using the function of max(D)

I will need to return the row/column of the
resulting "max" number within the database.

i would also like to make the result a variable in a new
function.

thanks for the help ahead of time.

 

[Frank Kabel]

Hi
try for example
=MATCH(MAX(D11000),D11000,0)
to return the row number