close
Blogtrottr
Yahoo!奇摩知識+ - 分類問答 - 電腦網路 - 已解決
Yahoo!奇摩知識+ - 分類問答 - 電腦網路 - 已解決 
Publish Your Book on Kindle

Learn to self-publisher your book on Kindle. Boost your brand and credibility with this step-by-step training course for just $99. Enroll today.
From our sponsors
想請問大家如何用EXCEL計算
Oct 15th 2013, 10:41

A1輸入"期數",B1輸入"次數"
實際的期數,次數由第2列以下開始放
D1輸入"上一期出現0下一期出現1的次數"
用以下的程式,可算出上一期出現0下一期出現1的次數,顯示在D2

Sub my_count()

Dim i, c As Integer

i = 3
c = 0
Do While Worksheets("Sheet1").Cells(i, 2) <> ""
If Worksheets("Sheet1").Cells(i - 1, 2) = 0 And Worksheets("Sheet1").Cells(i, 2) = 1 Then
c = c + 1
End If
i = i + 1
Loop

Worksheets("Sheet1").Cells(2, 4) = c

End Sub

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. Five Filters recommends:

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

    進擊的巨人14, 進擊的巨人線上看, 進擊的巨人漫畫, 進擊的巨人遊戲, 進擊的巨人 動畫, 進擊的巨人 線上漫畫, 進擊的巨人14線上看, 進擊的巨人13, 進擊的巨人 h, 進擊的巨人op

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

    E-mail轉寄