excel中，输入残疾证号，如何根据倒数第二位数值 自动输出 残疾类别

在B1输入公式下拉，如下图

=IF(A1="","",CHOOSE(--MID(A1,19,1),"视力","听力","言语","肢体","智力","精神","多重"))

假设你输入的残疾证号码在A1单元格，在需要结果的地方输入：

=LOOKUP(VALUE(LEFT(RIGHT(A1,2))),{1,2,3,4,5,6,7},{"视力","听力","言语","肢体","智力","精神","多重"})

假定A1单元格是残疾证号
公式:
=CHOOSE(1+LEFT(RIGHT(0&A1,2)),"","视力","听力","言语","肢体","智力","精神","多重","","")

或
=CHOOSE(1+IF(ISNUMBER(A1),LEFT(RIGHT(0&A1,2)),0),"","视力","听力","言语","肢体","智力","精神","多重","","")

=IF(A1="","",CHOOSE(--MID(A1,LEN(A1)-1,1),"视力","听力","言语","肢体","智力","精神","多重"))
或
=IF(A1="","",MID("视力听力言语肢体智力精神多重",MID(A1,LEN(A1)-1,1)*2-1,2))
下拉填充。

首先建立辅助列，输入以下公式：
右向左取数 =RIGHT(A1,2)
然后对辅助列进行排序，相同的数据就排在一起了。