close
Blogtrottr
Yahoo!奇摩知識+ - 分類問答 - 電腦網路 - 發問中
Yahoo!奇摩知識+ - 分類問答 - 電腦網路 - 發問中 
Looking for something light while keeping you safe and comfortable during extended waterside activities?

Shop New Drainmaker Shoe for Men, Women and Kids at Columbia!
From our sponsors
如何在excel裡快速的把不同的數據或是物名找出來
Feb 22nd 2014, 23:50

A1 B1 C1 .. X1

小王 小王 小明 小明

小星 小明 大王 小紅

小明 小紅 小王 小星

小紅 小王 小紅 小星

如果我把A欄所有的當作標準,在B欄至後面X欄所有的儲存格內,只要不符合A欄內的(小王,小星,小明,小紅)都是錯誤的,如C3(大王)和C4(大大),如何設定或是公式去把不相同於A欄的標示找出來呢?

謝謝

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
arrow
arrow
    全站熱搜

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