B3:C3區域組公式 右拉 下拉{=RIGHT(SMALL(RANDBETWEEN(ROW(INDIRECT(1&":"&C$2-B$2+1))^0,99)*10^9+ROW(INDIRECT(B$2&":"&C$2)),{1,2}),9)*1
区域数组公式 :公式下B3-->ENTER-->圈選B3:C3->游標放公式上-->shift+ctrl+enter三鍵一起按
B11{=AND((B3:B9<>C3:C9)*(B3:C9>=B2)*(B3:C9<=C2))
B11 複製到 D11 F11 H11
方式二 B3:B9{=SMALL(ROW(INDIRECT(B$2&":"&C$2)),RANDBETWEEN(1,C$2-B$2+1))
方式二 C3:C9{=SMALL(IF(B16<>ROW(INDIRECT(B$2&":"&C$2)),ROW(INDIRECT(B$2&":"&C$2))),RANDBETWEEN(1,C$2-B$2))
B3:C9 複製到 D3:I9
留言
張貼留言