Saturday, September 10, 2011

yogi_Select Names Of Top Scorers

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                            www.energyefficientbuild.com
saxxoo said:
selecting names with highest score
I got this formula I'm using for selecting a name (B row) with the highest number (H row)

I looked through the formulas without finding anything that seemed to fit my need, so is there any way to get it to give out like the best
5 names instead of just the one with the highest number.?
=ARRAYFORMULA(SUBSTITUTE(CONCATENATE( FILTER(B2:B91; H2:H91=MAX (H2:H91))&", ")&",";", ,";""))
-----------------------------------------------------------------