求高手相助，学生成绩等级评定

fgq5910

=XLOOKUP(I6, PERCENTILE(IF((C$6:C$4455=C6)*(E$6:E$4455=E6), I$6:I$4455), {0,0.1,0.4,0.7,0.9}), {"E","D","C","B","A"}, , -1)

zhaoxuie

mengrs 发表于 2025-12-18 19:38
=LET(a,(COUNTIFS(C:C,C6,E:E,E6,I:I,">"&I6)+1)/COUNTIFS(C:C,C6,E:E,E6),IFS((a>0.9)+(I6=0),"E",a>0.6 ...

非常感谢，亲测有效，谢谢大佬！