求助公式

5698d

请看附件  谢谢

GG函数

截图发出来

无聊的黑猫

=IF(AND(MMULT(TRANSPOSE((SUBSTITUTE(ABS(B5:F5-B4:F4),TRANSPOSE(ABS(B5:F5-B4:F4)),"@")="@")*1),ROW($1:$5)^0)=1),4,IF(OR(MMULT(TRANSPOSE((SUBSTITUTE(ABS(B5:F5-B4:F4),TRANSPOSE(ABS(B5:F5-B4:F4)),"@")="@")*1),ROW($1:$5)^0)=5),3,IF(AND(ISNUMBER(FIND({3,2},CONCAT(MMULT(TRANSPOSE((SUBSTITUTE(ABS(B5:F5-B4:F4),TRANSPOSE(ABS(B5:F5-B4:F4)),"@")="@")*1),ROW($1:$5)^0))))),6,IF(OR(MMULT(TRANSPOSE((SUBSTITUTE(ABS(B5:F5-B4:F4),TRANSPOSE(ABS(B5:F5-B4:F4)),"@")="@")*1),ROW($1:$5)^0)=4),5,IF(SUM((MMULT(TRANSPOSE((SUBSTITUTE(ABS(B5:F5-B4:F4),TRANSPOSE(ABS(B5:F5-B4:F4)),"@")="@")*1),ROW($1:$5)^0)=2)*1)/2=2,9,IF(OR(MMULT(TRANSPOSE((SUBSTITUTE(ABS(B5:F5-B4:F4),TRANSPOSE(ABS(B5:F5-B4:F4)),"@")="@")*1),ROW($1:$5)^0)=3),8,IF(OR(OR(ABS(E5:F5-E4:F4)=ABS(D5-D4)),ABS(E5-E4)=ABS(F5-F4)),2,IF(OR(ABS(D5:F5-D4:F4)=ABS(C5-C4)),1,IF(OR(ABS(C5:F5-C4:F4)=ABS(B5-B4)),0,)))))))))  三键  来个超长火车

5698d

无聊的黑猫 发表于 2023-3-25 16:34
=IF(AND(MMULT(TRANSPOSE((SUBSTITUTE(ABS(B5:F5-B4:F4),TRANSPOSE(ABS(B5:F5-B4:F4)),"@")="@")*1),ROW( ...

奇怪了，图片上公式是对的，我复制过来怎么是错的呢        




是有些函数找不到，唯独 显示 6的 是错误的  ISNUMBER     FIND        CONCAT

丢丢表格

5698d 发表于 2023-3-25 18:35
奇怪了，图片上公式是对的，我复制过来怎么是错的呢        

=SUMIF(Sheet2!B:B,SUM(3^MATCH(ABS(B5:F5-B4:F4),ABS(B5:F5-B4:F4),)),Sheet2!A:A)

5698d

丢丢表格 发表于 2023-3-25 19:13
=SUMIF(Sheet2!B:B,SUM(3^MATCH(ABS(B5:F5-B4:F4),ABS(B5:F5-B4:F4),)),Sheet2!A:A)

能不能不用辅助列呢？ 结果显示8的，显示5了

5698d

早上好，周末愉快！

tchh666

1. =CHOOSE(SUM(N(MATCH(ABS(B5:F5-B4:F4),ABS(B5:F5-B4:F4),)=COLUMN(A:E))),3,IF(SUM(N(ABS(B5:F5-B4:F4)=MODE(ABS(B5:F5-B4:F4))))=4,5,6),IF(SUM(N(ABS(B5:F5-B4:F4)=MODE(ABS(B5:F5-B4:F4))))=2,9,8),IF(OR(ABS(B5-B4)=ABS(C5:F5-C4:F4)),0,IF(OR(ABS(C5-C4)=ABS(D5:F5-D4:F4)),1,2)),4)

复制代码

5698d

tchh666 发表于 2023-3-26 08:36

你真棒  谢谢