几列数据分配到一行各个单元格

p58535860 · 发表于 2022-12-24 11:22

niko88819 发表于 2022-12-24 11:01
数组公式

我知道是数组，可我三键怎么不对了

p58535860 · 发表于 2022-12-24 11:24

niko88819 发表于 2022-12-24 11:01
数组公式

已经按三键

p58535860 · 发表于 2022-12-24 11:44

niko88819 发表于 2022-12-24 11:01
数组公式

老师，我知道我错那里，我没定位公式右啦，是随便在一个地方拉公式的。谢谢了

临在 · 发表于 2022-12-24 11:49

=LARGE(IFERROR(IF(FREQUENCY($C$1:$F$11,$C$1:$F$11)>0,$C$1:$F$11," ")," "),COLUMN(A1))
数组公式

无聊的黑猫 · 发表于 2022-12-24 14:36

=INDEX(UNIQUE(MID(","&TEXTJOIN(",",1,$C$1:$F$11)&",",FIND("@",SUBSTITUTE(","&TEXTJOIN(",",1,$C$1:$F$11)&",",",","@",ROW($A$1:$A$99)))+1,FIND("@",SUBSTITUTE(","&TEXTJOIN(",",1,$C$1:$F$11)&",",",","@",ROW($A$2:$A$100)))-FIND("@",SUBSTITUTE(","&TEXTJOIN(",",1,$C$1:$F$11)&",",",","@",ROW($A$1:$A$99)))-1)),COLUMN(A1))
抱歉审题错误顺序不同没事把

青青草2018 · 发表于 2022-12-27 17:47

本帖最后由青青草2018 于 2022-12-27 17:59 编辑

=INDEX(UNIQUE(MID(TEXTJOIN(,,$C$1:$C$11,$E$1:$E$11,$D$1:$D$11,$F$1:$F$11),ROW($1:$60)*2-1,2)),COLUMN(A1),1) 数组公式三键结束

		自动登录	找回密码
密码			免费注册

[求助] 几列数据分配到一行各个单元格