Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display adjacent cell as result...
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display adjacent cell as result...
=INDEX(A1:A10,MATCH(MAX(B1:B10),B1:B10,0))
-- Kind regards, Niek Otten "prspiderman" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display adjacent cell as result...
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 -- Gary's Student "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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA | Excel Worksheet Functions | |||
Adding colour to result in a cell? | Excel Discussion (Misc queries) | |||
How can i change this VBA project According to Indian Numeric | Excel Discussion (Misc queries) | |||
Numeric content in one cell ( implicit formula ) and the result in another one | Excel Discussion (Misc queries) | |||
Conversion | Excel Worksheet Functions |