close
Blogtrottr
Yahoo!奇摩知識+ - 分類問答 - 電腦網路 - 發問中
Yahoo!奇摩知識+ - 分類問答 - 電腦網路 - 發問中 
Own the Game.

Elevate your game with the newest adidas men's soccer footwear and apparel.
From our sponsors
Excel顯示問題
Oct 25th 2013, 02:05

現在有一個分頁A資料如下

品項....廠商A...廠商B...廠商C...廠商D...廠商E...廠商F
商品A....3...........5..........7....................10
商品B................10.........1.....................7..........9
商品C
商品D.................3.................................8
商品E
商品F....1.........................................................10
商品G.............................9

我想再分頁B顯示成如下

品項....廠商A...廠商B...廠商C...廠商E...廠商F
商品A....3...........5..........7.........10
商品B................10.........1..........7..........9
商品D.................3.....................8
商品F....1..............................................10
商品G.............................9

將廠商D因為無任何商品銷貨
所以顯示在分頁B時將其忽略或移除
而商品C跟商品E無廠商銷貨
所以顯示時一樣將其忽略或移除
請問我該再分頁B輸入何種函數
或者多項輔助函數才行

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 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
    全站熱搜
    創作者介紹
    創作者 gyyii9kz3svfv 的頭像
    gyyii9kz3svfv

    線上遊戲排行榜2013/2014,進擊的巨人線上看,candy crush saga外掛,正妹寫真三圍

    gyyii9kz3svfv 發表在 痞客邦 留言(0) 人氣()