[已解决]玩个缝合怪！去重三合一

xpql

琢磨去重复数提取终于有了些结果，但为此要增加三列辅助列，有没有大神可以简化公式与步骤，三合一并为一个简洁的函数公式！

最佳答案

月排行榜 / 总排行榜

hcm19522

2023-2-27 10:39

L3{=IFERROR(INDIRECT(TEXT(RIGHT(MIN(IF((COUNTIF(A:A,D$2:G$11)=0)*(COUNTIF(L$2:L2,D$2:G$11)=0),ROW($2:$11)/1%+{4,5,6,7}*10001)),4),"!R0C00"),),"")

跳转到最佳答案楼层

hcm19522

L3{=IFERROR(INDIRECT(TEXT(RIGHT(MIN(IF((COUNTIF(A:A,D$2:G$11)=0)*(COUNTIF(L$2:L2,D$2:G$11)=0),ROW($2:$11)/1%+{4,5,6,7}*10001)),4),"!R0C00"),),"")

xpql

hcm19522 发表于 2023-2-27 10:39
L3{=IFERROR(INDIRECT(TEXT(RIGHT(MIN(IF((COUNTIF(A:A,D$2:G$11)=0)*(COUNTIF(L$2:L2,D$2:G$11)=0),ROW($2 ...

谢谢老师。{4,5,6,7}搞明白COLUMN(D:G)更方便解读