Excel中搜尋相鄰的上下或左右兩個儲存格為結果:－線上遊戲排行榜2013/2014,進擊的巨人線上看,candy crush saga外掛,正妹寫真三圍

Blogtrottr

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

Kindle Book Deals

We find the best deals on best-selling Kindle books for you. Just tell us which genres you love and we'll do the rest. The best part? It's completely free!

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