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))&", ")&",";", ,";""))
-----------------------------------------------------------------
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))&", ")&",";", ,";""))
-----------------------------------------------------------------
No comments:
Post a Comment