如何在高中低范围内随机抽取5个不重复的数据

Monster、

如何在高中低范围内随机抽取5个不重复的数据 随机抽取1.zip (8.42 KB, 下载次数: 20)

2024-9-14 01:44 上传

点击文件名下载附件

无关岁月

区域数组，低版本的话需要选中E4：I4，编辑栏输入公式，三键结束

1. =INDEX(A:A,RIGHT(SMALL(IF(B$2:B$44=D4,RANDBETWEEN(ROW($1:$43)^0,999)/1%+ROW($2:$44)),COLUMN(A:E)),2))

复制代码

leepoison

1. =DROP(REDUCE("",D4:D6,LAMBDA(x,y,VSTACK(x,VSTACK(LET(a,FILTER(A2:A44,B2:B44=y),TRANSPOSE(TAKE(SORTBY(a,RANDARRAY(COUNTA(a))),5))))))),1)

复制代码

hxj119

1. =DROP(REDUCE("",{"高";"中";"低"},LAMBDA(x,y,LET(a,SORTBY(A2:B44,RANDARRAY(ROWS(A2:B44)),1),b,FILTER(CHOOSECOLS(a,1),CHOOSECOLS(a,2)=y),VSTACK(x,HSTACK(y,TOROW(TAKE(b,5))))))),1)

复制代码

晚风风

参与一下，
E4=TOROW(TAKE(LET(s,UNIQUE(FILTER($A$2:$A$44,$B$2:$B$44=$D4)),SORTBY(s,RANDARRAY(COUNTA(s)))),5)),下拉

yh7921

1. =TRANSPOSE(TAKE(SORTBY(FILTER($A$2:$A$44,$B$2:$B$44=D4),RANDARRAY(COUNTA(FILTER($B$2:$B$44,$B$2:$B$44=D4)))),5))

复制代码

啸海

=INDEX($A:$A,SMALL(IF(COUNTIF($D4,$B$2:$B$44)+COUNTIF($D4:D4,$A$2:$A$44)=1,ROW($2:$44)),RANDBETWEEN(1,COUNT(0/(COUNTIF($D4,$B$2:$B$44)+COUNTIF($D4:D4,$A$2:$A$44)=1)))))
三键右拉下拉

comeet

=LET(t,FILTER(A:A,B:B=D4),TRANSPOSE(TAKE(SORTBY(t,RANDARRAY(COUNTA(t))),5)))

ww87725244

=INDEX(FILTER($A$2:$A$44,$B$2:$B$44=$D6),TOROW(TAKE(UNIQUE(TOCOL(RANDARRAY(1,10,1,COUNTIF($B$2:$B$44,$D6),1))),5)),)

忙到飞起

=INDEX(FILTER(A2:A44,B2:B44=D4),RANDARRAY(,5,1,COUNTIF(B2:B44,D4),TRUE))