Formula

  • Thread starter Thread starter Ali
  • Start date Start date
A

Ali

I have columns A and B column A has names column B has
numbers. I want to run a formula that will not only give
me the max number in B but give me the corresponding name
in column A.

thanks in advance for your help.
 
You'll need 2 formulas as a formula can only display 1 result. The formula
that returns the matching value in column A can be something like this:

=INDEX(A1:A10,MATCH(MAX(B1:B10),B1:B10,FALSE))
 
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

Excel Help to copy information from one row at a time to another sheet 1
Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
retrieving values from a certain column 2
formula error 1
counting blank cells within two columns 2
Excel Subtracting multiple columns from another column 3
Having Blank Cells, etc. ? 1
Formula to return desired Result 4

Back
Top