Max function with cell lookup

  • Thread starter Thread starter Scott
  • Start date Start date
S

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: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.
 
Hi
try for example
=MATCH(MAX(D1:D1000),D1:D1000,0)
to return the row number
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Making MAX and MIN range variable 1
Max function for row with named cells 3
Wrong results from MATCH function 3
How do I reference the cell which returned a lookup value? 1
insert column header in cell below result of max FUNCTION 2
Lookup 1
Lookup returning wrong results 0
looking up cell address 1

Back
Top