how do I get this

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to find a function that find the max. value in one column but
return the corrosponding value from a different column though in the same row.
 
=index(a1:a10,match(max(b1:b10),b1:b10,0))
I'm trying to find a function that find the max. value in one column but
return the corrosponding value from a different column though in the same row.
Click to expand...
 
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

Minimum Value 2
Automation of info 2
How do I reference the cell which returned a lookup value? 1
Copyit Macro 16
lookup macro?? 9
Help with Vlookup and MAX functions 4
Lookup Question 5
APPROXIMATE SEARCH OF ANY ENTRY IN A COLUMN 1

Back
Top