| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Possible to "understand and pull" highest value from column B.....
My questions is this:
Is it possible to understand and pull the highest value from column B, then "read" across to column A to pull specific name associated with the highest value. Column A Column B Column C George 15 **George** (After understanding high value) Mike 12 Effectively I want a formula for excel to search for highest value in column B, then effectively pull the name associated with the highest value to Column C. Is this possible? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Possible to "understand and pull" highest value from column B.....
Try this:
=INDEX(A1:A10,MATCH(MAX(B1:B10),B1:B10,0)) -- Biff Microsoft Excel MVP "jamesjohns82" wrote in message ... My questions is this: Is it possible to understand and pull the highest value from column B, then "read" across to column A to pull specific name associated with the highest value. Column A Column B Column C George 15 **George** (After understanding high value) Mike 12 Effectively I want a formula for excel to search for highest value in column B, then effectively pull the name associated with the highest value to Column C. Is this possible? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Possible to "understand and pull" highest value from column B.
Wow, that is great. Thank you very much.
"T. Valko" wrote: Try this: =INDEX(A1:A10,MATCH(MAX(B1:B10),B1:B10,0)) -- Biff Microsoft Excel MVP "jamesjohns82" wrote in message ... My questions is this: Is it possible to understand and pull the highest value from column B, then "read" across to column A to pull specific name associated with the highest value. Column A Column B Column C George 15 **George** (After understanding high value) Mike 12 Effectively I want a formula for excel to search for highest value in column B, then effectively pull the name associated with the highest value to Column C. Is this possible? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Possible to "understand and pull" highest value from column B.
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "jamesjohns82" wrote in message ... Wow, that is great. Thank you very much. "T. Valko" wrote: Try this: =INDEX(A1:A10,MATCH(MAX(B1:B10),B1:B10,0)) -- Biff Microsoft Excel MVP "jamesjohns82" wrote in message ... My questions is this: Is it possible to understand and pull the highest value from column B, then "read" across to column A to pull specific name associated with the highest value. Column A Column B Column C George 15 **George** (After understanding high value) Mike 12 Effectively I want a formula for excel to search for highest value in column B, then effectively pull the name associated with the highest value to Column C. Is this possible? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Chg 1 "Last, First Mid" column to 3 "First", "Middle", "Last" colu | Excel Discussion (Misc queries) | |||
| How do I change the column heading in Excel to display "A" "B" "C | New Users to Excel | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
| Help to understand "IF" code | New Users to Excel | |||
| if one cell has "X" textin contents, then pull cell "Y"... | Excel Worksheet Functions | |||
Linear Mode
