分數轉換等級 (14754)

日期：

C2=LOOKUP(RANK(B2,B:B)/COUNT(B$2:B99),{0,31,66,90}%,{"A","B","C","D"})

D2=LOOKUP(RANK(B2,B:B)/COUNT(B$2:B99),F$2:F5,G$2:G5)



留言

張貼留言