B1 公式:=IF(OR(AND(ISERROR(FIND({4,7,3,9,6,8,5},A1))),AND(ISERROR(FIND({1,3,0,6,2,5},A1))),AND(ISERROR(FIND({4,1,7,0,9,2,8},A1)))),"全路","")C1 公式:=IF(NOT(AND(ISERROR(FIND({4,1,7,3,0,9,6,2,8,5},A1)))),IF(NOT(AND(ISERROR(FIND({4,1,7,3,0,9,6,2,8,5},A1)))),IF((AND(ISERROR(FIND({4,1,7,3,0,9,6,2,8,5},A1))))," 01路",""),""),"")...
|