| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
choosing the a cell from a range
=IF(B1=(LARGE($B$1:$B$10,{1})),B1,"") based on the formula to the left i am
able to identify the highest scoring person. However, now i want to display that person's name a separate cell on top of the sheet.... so, i need a function that looks at column C1:C10 and returns "Sue" Or instead of having to do the formula above... have a funtions that looks at the data and returns "Sue" Thank you in advance for your help! Joe 1 Robert 2 Steve 5 Sebastian 6 Karen 10 Sue 50 50 Bernice 30 Mary 40 Ben 9 Dan 10 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
choosing the a cell from a range
=INDEX(A1:A10,MATCH(MAX(B1:B10),B1:B10,0))
"Robert-Alpha" skrev: =IF(B1=(LARGE($B$1:$B$10,{1})),B1,"") based on the formula to the left i am able to identify the highest scoring person. However, now i want to display that person's name a separate cell on top of the sheet.... so, i need a function that looks at column C1:C10 and returns "Sue" Or instead of having to do the formula above... have a funtions that looks at the data and returns "Sue" Thank you in advance for your help! Joe 1 Robert 2 Steve 5 Sebastian 6 Karen 10 Sue 50 50 Bernice 30 Mary 40 Ben 9 Dan 10 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
choosing the a cell from a range
Perfect... thank you
"excelent" wrote: =INDEX(A1:A10,MATCH(MAX(B1:B10),B1:B10,0)) "Robert-Alpha" skrev: =IF(B1=(LARGE($B$1:$B$10,{1})),B1,"") based on the formula to the left i am able to identify the highest scoring person. However, now i want to display that person's name a separate cell on top of the sheet.... so, i need a function that looks at column C1:C10 and returns "Sue" Or instead of having to do the formula above... have a funtions that looks at the data and returns "Sue" Thank you in advance for your help! Joe 1 Robert 2 Steve 5 Sebastian 6 Karen 10 Sue 50 50 Bernice 30 Mary 40 Ben 9 Dan 10 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
choosing the a cell from a range
works great... however, what if two people have the same exact score? it
looks like based on the function below the first occurance is picked up... can i build some kind of warning or can i show both names? "excelent" wrote: =INDEX(A1:A10,MATCH(MAX(B1:B10),B1:B10,0)) "Robert-Alpha" skrev: =IF(B1=(LARGE($B$1:$B$10,{1})),B1,"") based on the formula to the left i am able to identify the highest scoring person. However, now i want to display that person's name a separate cell on top of the sheet.... so, i need a function that looks at column C1:C10 and returns "Sue" Or instead of having to do the formula above... have a funtions that looks at the data and returns "Sue" Thank you in advance for your help! Joe 1 Robert 2 Steve 5 Sebastian 6 Karen 10 Sue 50 50 Bernice 30 Mary 40 Ben 9 Dan 10 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing the format of a cell after choosing from a combobox. | Excel Discussion (Misc queries) | |||
| How do I populate an entire row by choosing one cell from a list | Excel Discussion (Misc queries) | |||
| In an excel cell,choosing a value,similar to combobox in VB - reg | New Users to Excel | |||
| Excel formula(?) for choosing only 1 cell.. | Excel Discussion (Misc queries) | |||
| choosing a cell with a comment | Excel Discussion (Misc queries) | |||
![Robert-Alpha[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
