想請問大家如何用EXCEL計算:－線上遊戲排行榜2013/2014,進擊的巨人線上看,candy crush saga外掛,正妹寫真三圍

Blogtrottr

Yahoo!奇摩知識+ - 分類問答 - 電腦網路 - 已解決

CloudMailin

Incoming Email for your web app. Get started in minutes and scale effortlessly when you need it.

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:

Massacres That Matter - Part 1 - 'Responsibility To Protect' In Egypt, Libya And Syria
Massacres That Matter - Part 2 - The Media Response On Egypt, Libya And Syria
National demonstration: No attack on Syria - Saturday 31 August, 12 noon, Temple Place, London, UK

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