[算表] 對照資料
軟體: Excel
版本: 2007
左右對照並找出右邊所缺少的33間學校。
除了一個一個比對之外，要如何做才會比較快呢？
函數是要用vlookup、match 還是 index？
請版上的大大們給小弟一點意見，感謝！
資料連結：
http://www.mediafire.com/view/5l59mc8lgqm3f86/Book1.xls
--
Perhaps death was no more than a long sleep from which you don't need to
wake up.
I wouldn't have been better if you had told me the truth.
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 111.249.193.236
※ 文章網址: https://www.ptt.cc/bbs/Office/M.1431533903.A.BF4.html
→
05/14 07:58, , 1F
05/14 07:58, 1F
→
05/14 10:17, , 2F
05/14 10:17, 2F
Office 近期熱門文章
PTT數位生活區 即時熱門文章
