View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gilbo Gilbo is offline
external usenet poster
 
Posts: 10
Default 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.