=SEQUENCE(10)
=SEQUENCE(10,2)
=SEQUENCE(10,2,2,2)
传统解法▼ =OFFSET($A$1,ROW(A1)*4-4+COLUMN(A1),0)&'')
365函数解法▼ =INDEX(A2:A100,SEQUENCE(5,4))&''
=RANDARRAY(10)
=RANDARRAY(10,2,1,100,TRUE)
=INDEX(SORTBY(A2:A14,RANDARRAY(13)),SEQUENCE(3))
=IFERROR( INDEX(SORTBY(A2:A14,RANDARRAY(13)),SEQUENCE(10,3)),'')
联系客服