Display adjacent cell as result...

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

Guest

Hello Gang:
I have two colums, Column A (Val1) and Column B (a number such as 456). If
I use the expression =max(b1:b10) I get the highest value for that column,
but what what I need is the adjacent cell name such as Val1.

Thanks for the help in advance...
 
Use MATCH() to find in what row the maximum is located and then INDIRECT() go
get the text value from column A:


in C1 enter:
=MAX(B1:B10) your max should appear

in D1 enter:
=MATCH(C1,B1:B10) the correct row number holding max should appear

in E1 enter:
=INDIRECT("A" & D1) the text in col A for that row should appear
 
Niek and Student, I really appreciate your time and expertise.

Thanks, problem solved, situation under control
 

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

Using =IF(B10<>"",COUNTA($B$10:B10),"") to number rows in columns other than A 2
Formula for max number and the data adjacent to the cell 3
How to make a VBA Function return a value in percent format 8
Counting unique values in multiple columns 4
Formula - Is it possible to... 3
adjacent to highest Digit 3
Concatenating adjacent cells ignoring blanks and adding a delimite 3
Macro to Sum Two Adjacent Columns as per Text in previous Column 8

Back
Top