close
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
arrow
arrow
    全站熱搜
    創作者介紹
    創作者 nbvo4o2861kqd 的頭像
    nbvo4o2861kqd

    線上遊戲排行榜2013/2014,進擊的巨人線上看,candy crush saga外掛,正妹寫真三圍

    nbvo4o2861kqd 發表在 痞客邦 留言(0) 人氣()

    E-mail轉寄