英文字母排名 (13050)

C2=IFERROR((FIND(B2,"A+A A-B+B-C+C-D+D-")+(RIGHT(B2)<>""))/2+(B2="A"),"")

另解=IFERROR(FIND(LEFT(B2),"A  B C D")+(RIGHT(B2)="-")+(LEFT(B2)="A")*(B2<>"A+"),"")

另解=IFERROR(MATCH(B2,{"A+","A","A-","B+","B-","C+","C-","D+","D-"},),"")