最新核准日期的評等 (12060)

C2=LOOKUP(1,0/(E$2:E$16=A2)/(F$2:F$16<=B2),G$2:G$16)

核准日無升冪排序 {=INDEX(G:G,RIGHT(MAX((E$2:E$16=A2)*(F$2:F$16<=B2)*F$2:F$16/1%+ROW($2:$16)),2))