隨機取多組 非空且不重複 (11221)


I2{=IFERROR(INDEX($A$2:$G$2,SMALL(IF((COUNTIF(I$1:I1,$B$2:$G$2)=0)*($B$2:$G$2<>""),COLUMN($B:$G)),RANDBETWEEN(1,COUNT($B$2:$G$2)-ROW(A1)+1))),"")


留言