EXCEL 以儲存格的內容,取最後一列的數值:Realtime－進擊的巨人14, 進擊的巨人線上看, 進擊的巨人漫畫, 進擊的巨人遊戲, 進擊的巨人動畫, 進擊的巨人線上漫畫, 進擊的巨人14線上看, 進擊的巨人13, 進擊的巨人 h, 進擊的巨人op

Blogtrottr

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

EXCEL 以儲存格的內容,取最後一列的數值

Feb 16th 2015, 05:38

由於每次進貨價格都不同,我想取該商品以商品編號B為搜尋標地的最後一列進貨價格C(也是最新的進貨價格),其公式為何?

範例:

ABC
日期商品編號進價
2015/01/02A0000115
2015/01/02A0000249
2015/01/04A0000114
2015/01/04A0000249
2015/01/04A0000113
2015/01/04A0000249
2015/01/06A0000116
2015/01/06A0000249
2015/01/07A0000116
2015/01/07A0000249
2015/01/09A0000117
2015/01/09A0000249
2015/01/10A0000118
2015/01/10A0000251

Recommended article: Chomsky: We Are All – Fill in the Blank.
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