Excel中搜尋相鄰的上下或左右兩個儲存格為結果:－2016徵求年菜推薦網路訂購最紅的商家.年菜訂購?台北年菜外送餐廳推薦(年菜)?年菜.今年不想做年菜推薦,網路宅配哪一家好?

Blogtrottr

Yahoo!奇摩知識+ - 分類問答 - 電腦網路 - 已解決

Who owns mobile strategy?

Who owns your mobile strategy, the CIO or the CMO? Kinvey's eBook breaks down the arguments for both sides with tips from business leaders and industry analysts.

From our sponsors

Excel中搜尋相鄰的上下或左右兩個儲存格為結果

Aug 12th 2013, 05:38

Excel中可否搜尋相鄰的上下或左右兩個儲存格為結果?
不是只搜尋兩個儲存格當範圍
而是大量資料中兩個相鄰的儲存格為結果
例如
資料中有ＤＤＣＣＤＣＤＤＤＣＣＤＤＣ
是否可搜尋Ｃ與Ｄ出來並在其中增加框線（儲存格中的框線）
變成
ＤＤＣＣ｜ＤＣ｜ＤＤＤＣＣ｜ＤＤＣ
因為資料蠻大量的
一筆一筆對怕會有錯誤
只需要ＣＤ中間加框線就好
因為不是所有的Ｃ後面都須加框線
用篩選出Ｃ來加框線也不行
不知道是否有更快的方法~
請幫解答，謝謝^^

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