close
Blogtrottr
Yahoo!奇摩知識+ - 分類問答 - 電腦網路 - 已解決
Yahoo!奇摩知識+ - 分類問答 - 電腦網路 - 已解決 
50% off Print Subscription of USA Today

Get the news delivered to your doorstep. Lock in the savings and receive USA Today for just $0.75 a day.
From our sponsors
如原式依複製貼上位址自動調整其參照的對應儲存格。
Aug 23rd 2013, 06:17

EXCEL.公式參照範圍指定格若為空白,公式不顯示(2)
                        <.准提部林.>
--------------------------------
公式:
 前一參照區第1格(F1)空白,公式顯示0(不顯示)!
 Z63公式:
 =IF(INDEX(Area2,1)="",0,COUNT(RANK((ROW(A1)-(Z$67>0))*10+Z$67,Area3))*ISNA(RANK((ROW(A1)-(Z$67>0))*10+Z$67,Area2))*((ROW(A1)-(Z$67>0))*10+Z$67))
 
 若要6格都有數字,才顯示:
 =IF(COUNT(Area2)=6,原公式,0)
--------------------------------
<範例檔>:
檔案名稱:20130823a02(saa-WB301-C).rar
下載位址:
http://www.funp.net/442780
--------------------------------

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 Say What You Like, Because They Like What You Say' - http://www.medialens.org/index.php/alerts/alert-archive/alerts-2013/731-you-say-what-you-like-because-they-like-what-you-say.html

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) 人氣()