Yahoo!奇摩知識+ - 分類問答 - 電腦網路 - 已解決 |
Yahoo!奇摩知識+ - 分類問答 - 電腦網路 - 已解決 |
|
|
想請問大家如何用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:
|
 |
|
candycrushsaga3 發表在 痞客邦 留言(0) 人氣()
Yahoo!奇摩知識+ - 分類問答 - 電腦網路 - 已解決 |
Yahoo!奇摩知識+ - 分類問答 - 電腦網路 - 已解決 |
|
 |
Manage your social media
Best social media tool for image publishing to Facebook and Twitter. Look amazing and delight your followers. Get 40% off when you sign up today.  |
From our sponsors |
|
|
實體店面與網路商城的威而鋼,犀利士,樂威壯差別
Oct 15th 2013, 13:08
實體店面來說的話一般男人會礙於面子而不去購買,而網路上面賣相關商品
的店家又非常多,我是經由網友的介紹,到了這個網站,
http://cialis888.com/ 購買了威而鋼,犀利士,樂威壯,效果很好,
貨到付款速度又快,隱私性又好,你可以參考看看。
參考資料 http://cialis888.com/
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:
|
 |
|
candycrushsaga3 發表在 痞客邦 留言(0) 人氣()