[請問] excel隨機亂數:－線上遊戲排行榜2013/2014,進擊的巨人線上看,candy crush saga外掛,正妹寫真三圍

Blogtrottr

批踢踢實業坊 ask 板

[請問] excel隨機亂數

Nov 19th 2013, 18:17, by lovepink0725

作者lovepink0725 (酷炫李奔奔)

看板ask

標題[請問] excel隨機亂數

時間Tue Nov 19 18:17:42 2013

我需要130組排列方式不重複的九宮格 (格內分別是數字1~9) 請問該如何用excel做出呢? 謝謝 -- ※ 發信站: 批踢踢實業坊(ptt.cc) ◆ From: 118.171.68.163

→ lovepink0725:或是1~9的不重複排列方式即可不需要做成九宮格 11/19 18:19

→ wxtab019:亂數用rand()產生0~1之間的小數然後*10 四捨五入到整數 11/19 18:28

→ wxtab019:就會有0~9的亂數如果不要0就寫個if弄掉吧或是自己刪 11/19 18:28

This entry passed through the Full-Text RSS service — if this is your content and you're reading it on someone else's site, please read the FAQ at fivefilters.org/content-only/faq.php#publishers.

You are receiving this email because you subscribed to this feed at blogtrottr.com.

If you no longer wish to receive these emails, you can unsubscribe from this feed, or manage all your subscriptions