要横竖都可以提取不重复数据，间隔2次 演示结果样式

shenzhenyang

要横竖都可以提取不重复数据，间隔2次  演示结果样式

谢谢老师们

jerrike

1. 横=LET(a,DROP(UNIQUE(A:A),1),TOROW(HSTACK(a,a)))[code]
   
2. 竖=LET(a,DROP(UNIQUE(A:A),1),TOCOL(HSTACK(a,a)))

复制代码

[/code]

shenzhenyang

jerrike 发表于 2024-7-16 10:48
[/code]

老师有没有不是365公式的，谢谢

hugeinfo

竖=IFERROR(INDEX(A:A,SMALL(IF(MATCH($A$2:$A$104,A:A,)=ROW($2:$104),ROW($2:$104),9^9),INT(ROW(A2)/2)+1)),"")

横=INDEX($A:$A,SMALL(IF(MATCH($A$2:$A$104,$A:$A,)=ROW($2:$104),ROW($2:$104),9^9),INT(COLUMN(B2)/2)))

无关岁月

竖

1. =IFERROR(INDEX(A:A,SMALL(IF(MATCH(A$2:A$104,A$2:A$104,)=ROW($1:$103),ROW($2:$104)+{0,1}),ROW(A1))),"")

复制代码

横

1. =IFERROR(INDEX($A:$A,SMALL(IF(MATCH($A$2:$A$104,$A$2:$A$104,)=ROW($1:$103),ROW($2:$104)+{0,1}),COLUMN(A1))),"")

复制代码

part98

1. =IFERROR(INDEX($A:$A,AGGREGATE(15,6,ROW($A$2:$A$104)/(MATCH($A$2:$A$104,$A$2:$A$104,)=ROW($A$1:$A$103)),ROUNDUP(ROW(A1)/2,0))),"")

复制代码

1. =IFERROR(INDEX($A:$A,AGGREGATE(15,6,ROW($A$2:$A$104)/(MATCH($A$2:$A$104,$A$2:$A$104,)=ROW($A$1:$A$103)),ROUNDUP(COLUMN(A1)/2,0))),"")

复制代码