|
|
1234的遍历出来了，1-8的循环的行数太多了，不弄了，看有没有大神吧
循环函数
=IFERROR(CONCAT(INDEX($E$13:$E$16,IF(COUNTA(INT(MOD((ROW(A1)-1)/(COUNTA($E$13:$E$16)^SEQUENCE(COUNTA($E$13:$E$16),,COUNTA($E$13:$E$16)-1,-1)),COUNTA($E$13:$E$16)))+1)=COUNTA(UNIQUE(INT(MOD((ROW(A1)-1)/(COUNTA($E$13:$E$16)^SEQUENCE(COUNTA($E$13:$E$16),,COUNTA($E$13:$E$16)-1,-1)),COUNTA($E$13:$E$16)))+1)),INT(MOD((ROW(A1)-1)/(COUNTA($E$13:$E$16)^SEQUENCE(COUNTA($E$13:$E$16),,COUNTA($E$13:$E$16)-1,-1)),COUNTA($E$13:$E$16)))+1,""))),FALSE)
筛选去重
=UNIQUE(FILTER(G:G,G:G<>FALSE)) |
|
