设数据简略如图:
将公式
=IF(OR(AND(A1-B1=B1-C1,A1-B1=-1),AND(B1-C1=-1,B1-C1=C1-D1),AND(C1-D1=-1,C1-D1=D1-E1),AND(D1-E1=-1,D1-E1=E1-F1)),"L3",IF(OR(AND(A1-B1=-1,A1-B1=C1-D1),AND(B1-C1=-1,B1-C1=D1-E1),AND(C1-D1=-1,C1-D1=E1-F1)),"D2",IF(OR(AND(A1-B1=B1-C1,A1-B1=-2),AND(B1-C1=-2,B1-C1=C1-D1),AND(C1-D1=-2,C1-D1=D1-E1),AND(D1-E1=-2,D1-E1=E1-F1)),"T3",IF(OR(AND(A1-B1=-2,A1-B1=C1-D1),AND(B1-C1=-2,B1-C1=D1-E1),AND(C1-D1=-2,C1-D1=E1-F1)),"T2",""))))
复制后粘贴到“G1”单元格,对准右下角,民“+”状时双击,效果如图:
Copyright © 2025 IZhiDa.com All Rights Reserved.
知答 版权所有 粤ICP备2023042255号