[算表] vlookup逆推回去
軟體:excel 2007
公司有內建條碼 可以轉成中文
例如
01 => aaa 01 => bb 01 => C
02 => Aa 02 => B 02 => cCc
03 => aAa 03 => Bb 03 => ccc
如果我輸入 010102 就會得到 aaabbcCc
輸入 030201 會得到 aAaBC
這個用vlookup還蠻容易做的
現在問題是要把 aaabbcCc 反推回010102
小弟還覺得蠻困擾的...字元長度不一樣 如果一樣應該還算好解決...
有任何的解法嗎??
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 122.117.101.164
※ 文章網址: http://www.ptt.cc/bbs/Office/M.1397656629.A.65A.html
→
04/16 22:10, , 1F
04/16 22:10, 1F
→
04/16 22:12, , 2F
04/16 22:12, 2F
→
04/16 22:19, , 3F
04/16 22:19, 3F
→
04/16 22:20, , 4F
04/16 22:20, 4F
→
04/16 22:44, , 5F
04/16 22:44, 5F
→
04/16 23:12, , 6F
04/16 23:12, 6F
→
04/17 00:20, , 7F
04/17 00:20, 7F
→
04/17 00:38, , 8F
04/17 00:38, 8F
→
04/17 00:45, , 9F
04/17 00:45, 9F
→
04/17 00:46, , 10F
04/17 00:46, 10F
→
04/17 00:47, , 11F
04/17 00:47, 11F
→
04/17 00:49, , 12F
04/17 00:49, 12F
→
04/17 00:52, , 13F
04/17 00:52, 13F
→
04/17 01:00, , 14F
04/17 01:00, 14F
→
04/17 01:17, , 15F
04/17 01:17, 15F
→
04/17 01:17, , 16F
04/17 01:17, 16F
→
04/17 01:40, , 17F
04/17 01:40, 17F
推
04/17 10:31, , 18F
04/17 10:31, 18F
→
04/17 11:02, , 19F
04/17 11:02, 19F
→
04/17 11:14, , 20F
04/17 11:14, 20F
Office 近期熱門文章
PTT數位生活區 即時熱門文章
