隨機 1~90 產生 5*5格不重複 (13698)

A9:J17=RAND()

A2:E6=RANK(A9,$A$9:$K$17)

G2{=AND(COUNTIF(A2:E6,A2:E6)=1)

J2:N6區域數組公式{=RIGHT(SMALL(RANDBETWEEN(ROW(1:90)^0,999)/1%+ROW(1:90),ROW(1:5)*5-5+{1,2,3,4,5}),2)*1

P2{=AND(COUNTIF(J2:N6,J2:N6)=1)