F2=SUM(LARGE(IF($A$2:$A$27=E2,$C$2:$C$27,0),ROW(INDIRECT(1&":"&ROUND(COUNTIF($A$2:$A$27,E2)*0.8,)))))/ROUND(COUNTIF($A$2:$A$27,E2)*0.8,)
æ°ç»å ¬å¼åä¸å¤å¶ãæ°ç»å ¬å¼ï¼å ¬å¼è¾å®åï¼å æ æ¾å¨å ¬å¼ç¼è¾æ åæ¶æä¸CTRL+SHIFT+å车é®ï¼ä½¿æ°ç»å ¬å¼çæã
å80%人æ°æåèäºå ¥è®¡ç®