1. A1 到 A100 的formula 放=ROW()


2. B1 到 B100 的formula 放=RANDBETWEEN(1,10000)


3. D1 的formula 放=SORT(A1:B100,2,1)


4. G1到G10 分别放以下formula
• =TRANSPOSE(D1:D10)
• =TRANSPOSE(D11:D20)
• =TRANSPOSE(D21:D30)
• =TRANSPOSE(D31:D40)
• =TRANSPOSE(D41:D50)
• =TRANSPOSE(D51:D60)
• =TRANSPOSE(D61:D70)
• =TRANSPOSE(D71:D80)
• =TRANSPOSE(D81:D90)
• =TRANSPOSE(D91:D100)


5. 预期成果在G1 到 P10. 按下F9 以获取新的随机成果





6. Formula 的方式

Source: ---

---

Disclaimer: The information in this webpage is shared by anonymous users from external online sources. We cannot guarantee its accuracy or truthfulness. Users should exercise caution and verify information independently.

---