[算表] match列號問題
軟體:excel 2007
不好意思 又來發問了><
假設我要取得產品A 版本2的列號 也就是 5
有加輔助欄的是打得出來 欄C那邊 把 欄A跟欄B連在一起
然後打在欄D打上 =match(A1&B1,C:C,0) 取得
請問有辦法在沒有輔助欄的狀態下取得嗎?
欄A 欄B
版本
產品A 1
產品B 1
產品B 2
產品B 3
產品A 2
產品A 3
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 125.231.81.98
→
03/12 23:40, , 1F
03/12 23:40, 1F
→
03/13 00:42, , 2F
03/13 00:42, 2F
推
03/13 00:52, , 3F
03/13 00:52, 3F
→
03/13 00:52, , 4F
03/13 00:52, 4F
→
03/13 00:52, , 5F
03/13 00:52, 5F
→
03/13 00:52, , 6F
03/13 00:52, 6F
→
03/13 00:52, , 7F
03/13 00:52, 7F
→
03/13 07:52, , 8F
03/13 07:52, 8F
→
03/13 07:53, , 9F
03/13 07:53, 9F
→
03/13 07:53, , 10F
03/13 07:53, 10F
→
03/13 07:53, , 11F
03/13 07:53, 11F
→
03/13 07:54, , 12F
03/13 07:54, 12F
→
03/13 07:54, , 13F
03/13 07:54, 13F
→
03/13 07:55, , 14F
03/13 07:55, 14F
→
03/13 07:55, , 15F
03/13 07:55, 15F
→
03/13 08:05, , 16F
03/13 08:05, 16F
→
03/13 08:05, , 17F
03/13 08:05, 17F
推
03/13 22:47, , 18F
03/13 22:47, 18F
→
03/13 22:47, , 19F
03/13 22:47, 19F
→
03/13 22:47, , 20F
03/13 22:47, 20F
→
03/13 22:47, , 21F
03/13 22:47, 21F
→
03/13 22:53, , 22F
03/13 22:53, 22F
推
03/13 23:04, , 23F
03/13 23:04, 23F