I've attempted a formula in BJ29 but have been unsuccessful. Can someone please take a quick look and let me know where I've gone wrong? The aim is to have the top 3 percentages (BI29:BI31), and then have the corresponding names from (BJ2:DI2) match with the percentage as found in (BJ23:DI23).
Cell Formulas | ||
---|---|---|
Range | Formula | |
BJ21:DI23 | BJ21 | =IFERROR(BJ14/INDEX('[ARD Performance 210511.xlsm]Database'!$A$38:$I$38,MATCH('[ARD Performance 210511.xlsm]Results'!$BI$11,'[ARD Performance 210511.xlsm]Database'!$A$5:$I$5,0)),"") |
BJ29 | BJ29 | =INDEX($BJ$2:$DI$2,AGGREGATE(15,6,(ROW($BJ$23:$DI$23)-ROW($BJ$23)+1)/($BJ$23:$DI$23=BI29),ROWS(BJ29:BJ$29))) |
BI29 | BI29 | =LARGE(BJ23:DI23,1) |
BI30 | BI30 | =LARGE(BJ23:DI23,2) |
BI31 | BI31 | =LARGE(BJ23:DI23,3) |
BI32 | BI32 | =LARGE(BJ21:DI21,1) |
BI33 | BI33 | =LARGE(BJ21:DI21,2) |
BI34 | BI34 | =LARGE(BJ21:DI21,3) |