| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Top 3 highest values
I have managed to get the three top values in a list with
=INDEX($R$3:$R$92,MATCH(LARGE($S$3:$S$92,1),$S$3:$ S$92,0)), =INDEX($R$3:$R$92,MATCH(LARGE($S$3:$S$92,2),$S$3:$ S$92,0)), =INDEX($R$3:$R$92,MATCH(LARGE($S$3:$S$92,3),$S$3:$ S$92,0)), but it does not allow for duplicates. Any Help would be great. Your thanks in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Highest Values Comparison | Excel Worksheet Functions | |||
| Average of Highest values | Excel Discussion (Misc queries) | |||
| Using the highest 2 out of 3 values in a formula | Excel Discussion (Misc queries) | |||
| 3 highest values | New Users to Excel | |||
| 3 highest values indicated using formatting | Excel Worksheet Functions | |||
Threaded Mode
