C2=LOOKUP(RANK(B2,B:B)/COUNT(B:B),{0,15,45,75}%+1%%,{"A","B","C","D"})
等級分 只適合 A~D=CHAR(69-MATCH(B2,PERCENTILE(B:B,{0,25,55,85}%)))
另解=MID("ABCD",MATCH(RANK(B2,B:B)/COUNT(B:B),{0,15,45,75}%+1%%),1)
另解=MID("DCBA",MATCH(B2,PERCENTILE(B:B,{0,25,55,85}%)),1)
留言
張貼留言