excel往前推找連續0的次數:－線上遊戲排行榜2013/2014,進擊的巨人線上看,candy crush saga外掛,正妹寫真三圍

Blogtrottr

Yahoo!奇摩知識+ - 分類問答 - 電腦網路 - 發問中

Find Unique T-shirts

Explore the most popular t-shirts on Cafepress. Discover great designs celebrating anything you can think of.

From our sponsors

excel往前推找連續0的次數

Oct 17th 2013, 21:07

A B C D E F G
3 1 2 4 0 0
5 0 0 0 0 1
3 4 1 0 0 0

問題如上,今最新資料為F行,想找出以F行往前推連續為0的次數,想要得出G1=2,
G2=0,G3=3,公式該怎麼寫啊?不知道我這樣的說明清楚嗎?麻煩各位大師了,謝謝!

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