考試全班不佳 加分控制不及格數 (13955)

D2=MIN(C2+59+(F$2=0)-SMALL(C:C,MAX(F$2-COUNTIF(C:C,SMALL(C:C,F$2))+1,1)),100)