| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Chosing the top 3 values from a list
an earlier Excel tip from this forum for picking the top person from a list INDEX, MATCH, and MAX functions in the following formula: =INDEX(A2:A9,MATCH(MAX(B2:B9),B2:B9,0)) How can the formula be amended to pick the 2nd and 3rd highest person. I have a list with names, would like to be able to chose and show the score and name of the top 3 people Thanks Stephen -- st120869 ------------------------------------------------------------------------ st120869's Profile: http://www.excelforum.com/member.php...o&userid=18330 View this thread: http://www.excelforum.com/showthread...hreadid=496633 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Chosing the top 3 values from a list
=INDEX(A2:A9,MATCH(Large(B2:B9,1),B2:B9,0))
=INDEX(A2:A9,MATCH(Large(B2:B9,2),B2:B9,0)) =INDEX(A2:A9,MATCH(Large(B2:B9,3),B2:B9,0)) It gets more complicated if there could be ties (ex, the top 3 each have the value 10). -- Regards, Tom Ogilvy "st120869" wrote in message ... an earlier Excel tip from this forum for picking the top person from a list INDEX, MATCH, and MAX functions in the following formula: =INDEX(A2:A9,MATCH(MAX(B2:B9),B2:B9,0)) How can the formula be amended to pick the 2nd and 3rd highest person. I have a list with names, would like to be able to chose and show the score and name of the top 3 people Thanks Stephen -- st120869 ------------------------------------------------------------------------ st120869's Profile: http://www.excelforum.com/member.php...o&userid=18330 View this thread: http://www.excelforum.com/showthread...hreadid=496633 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Chosing the top 3 values from a list
Thanks - this has really helped -- st120869 ------------------------------------------------------------------------ st120869's Profile: http://www.excelforum.com/member.php...o&userid=18330 View this thread: http://www.excelforum.com/showthread...hreadid=496633 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Identify & List unique values from a list using functions/formulas | Excel Worksheet Functions | |||
| create a list of single values from multiple values | Excel Worksheet Functions | |||
| Count unique values and create list based on these values | Excel Worksheet Functions | |||
| create list of unique values from a column with repeated values? | Excel Worksheet Functions | |||
| chosing record and editing it | Excel Programming | |||
![st120869[_7_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
