View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
prspiderman
 
Posts: n/a
Default Display adjacent cell as result...

Niek and Student, I really appreciate your time and expertise.

Thanks, problem solved, situation under control
--
Rafy Rivera
"Airborne Leads the way"


"prspiderman" wrote:

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...
--
Rafy Rivera