Find the largest numbers in a list

[Mangolili]

Is it possible to use an array formula to find the largest 5 numbers in a list of values, and input those values to different cells?

Please let me know. Thank you.

 

[BrandonWLH]

If they are all unique, you could just sort largest to smallest and take the top 5 and be done with it, or you need a real function to do that and grab the to p 5?

 

[Steve=True]

=large(a2:a7,1)
=large(a2:a7,2)
=large(a2:a7,3)
=large(a2:a7,4)
=large(a2:a7,1)

 

[Mangolili]

Thank you so much, it works. I wonder if the top 5 values can be match to the corresponding categories or names, using the match function?

 

[Steve=True]

Probably.

Here is a formula where i am matching a placement in a grid and then finding the smallest unit.

=IF(COUNTIF(Controls!$I$4:$I$1515,"<"&Controls!$L$4+1)>ROWS(Controls!$F$4:F6)-1,INDEX(Controls!$E$4:$E$1515,MATCH(SMALL(OFFSET(Controls!$I$3,1,0,COUNTIF(Controls!$I$4:$I$1515,13),1),ROWS(Controls!$A$4:A6)),Controls!$I$4:$I$1515,0))+365,"")

If you can't figure out your example, i suggest posting a sample file so someone can help you. www.4shared.com

 

[Aladin Akyurek]

Thank you so much, it works. I wonder if the top 5 values can be match to the corresponding categories or names, using the match function?

See e.g. post #7 in:

http://www.mrexcel.com/forum/showthread.php?t=342541

 

[Mangolili]

Thank you so much. I think this =INDEX(C:C,MATCH(E29,AI:AI,0)) will do, right?
What is E29 refer to?


I also read your response in post #7, but I don't fully understand everything. I am not sure how to implement your formula into my sheet.
My range is B4:B33.

 

[Aladin Akyurek]

Thank you so much. I think this =INDEX(C:C,MATCH(E29,AI:AI,0)) will do, right?
What is E29 refer to?


I also read your response in post #7, but I don't fully understand everything. I am not sure how to implement your formula into my sheet.
My range is B4:B33.

If B4:B33 house the scores, where are the performers/names? In A4:A33?

 

[Mangolili]

Yes, the A column is the names and the values are in the B column. I played with your example in excel and I got it. Though I don't get everything, but I understand how it works and applied it to my own data.

Thank you so much for the link to your example.

 

[Aladin Akyurek]

Yes, the A column is the names and the values are in the B column. I played with your example in excel and I got it. Though I don't get everything, but I understand how it works and applied it to my own data.

Thank you so much for the link to your example.

Great to hear that. Thanks for providing feedback.