EXCEL公式問題:Realtime－線上遊戲排行榜2013/2014,進擊的巨人線上看,candy crush saga外掛,正妹寫真三圍

Blogtrottr

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

EXCEL公式問題

Mar 30th 2015, 14:03

我有一份資料~內容約是

欄位A (搜尋範圍)

1. ABC123=DEF123-(編號)
2. DEF456=ABC456-(編號)
3. ABC456=DEF456-(編號)
4. DEF123=ABC123-(編號)
5. ABC456=DEF456-(編號)
6...........
7...........
.....後面來有很多類似這種模式

欄位B(指定搜尋條件)

ABC123
ABC456
DEF456

欄位C(設公式)
不會設~"~

這樣的內容按Ctrl+F,貼上"ABC123"再按全部尋找,會顯示
ABC123=DEF123-(編號)
DEF123=ABC123-(編號)

那有沒有辦法透過設公式來顯示我要的資料呢?.......求解>"<

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