函數~直式資料內容，橫式拖曳公式。:Realtime－線上遊戲排行榜2013/2014,進擊的巨人線上看,candy crush saga外掛,正妹寫真三圍

Blogtrottr

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

Take the Style Quiz

Join JustFab and get one pair of extraordinary shoes or bag every month, handpicked for you by our fashion experts.

From our sponsors

函數~直式資料內容，橫式拖曳公式。

Oct 18th 2014, 17:09

說明︰
Sheet1!
I1 =IF($A1="","",IF(COUNT(RANK($A1:$G1,Sheet2!$A$1:$F$1)),COUNT(RANK($A1:$G1,Sheet2!$A$1:$F$1)),""))
J1
=IF($A1="","",IF(COUNT(RANK($A1:$G1,Sheet2!$A$2:$F$2)),COUNT(RANK($A1:$G1,Sheet2!$A$2:$F$2)),""))
K1….IV1..其餘以此類推。

請問︰
Sheet1!I1公式中的$A$1:$F$1要如何改(表達)，才能右拉一式到位?

以上敬請各位先進不吝賜教是幸!謝謝!

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.

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