大佬们，还有其他公式代替吗？谢谢！！！

reptarray函数

不感兴趣

开通SVIP免广告

=TOCOL(REPTARRAY({"甲","乙","丙","丁"},5),,1)

=TOCOL(IF(SEQUENCE(,5),{"甲";"乙";"丙"}))

=TOCOL(IF({5;5;5}>=COLUMN(A:Z),{"甲";"乙";"丙"},1/0),3,0)

=mid("甲甲甲甲甲乙乙乙乙乙丙丙丙丙丙",row(1:15),1)

3000行的话
=choose(row(1000:3999)/1000,"甲","乙","丙")

=index(int(row(a1)/5)+1,{"甲","乙","丙"})

不感兴趣

开通SVIP免广告

感觉方法还是比较多的，我也来一个
=TOCOL(INDEX({"甲","乙","丙","丁"},INT(SEQUENCE(4,5,0)/5+1)))

=TOCOL({"甲","乙","丙"}&Z1:Z5,,1)

下载贴吧APP
看高清直播、视频！

分享到: