将设ABCDE在A列，在B列输入公式如下：B2=IF(A2=A,4,IF(A2=B,3,IF(A2=C,2,IF(A2=D,1,O))))
=lookup(a1,{"A","B","C","D","E"},{4,3,2,1,0})=69-CODE(A1)
替换！A替换成4...
