[問題] 延伸問題再一次600P~
軟體:Excel
版本:2010
1.
https://imgur.com/a/erdO0bu
如果我新增一欄F欄把原本的C欄刪掉
=IF(SUMPRODUCT((B3>=--LEFT(C$2:E$2,FIND("-",C$2:E$2)-1))*
(B3<=--MID(C$2:E$2,FIND("-",C$2:E$2)+1,5))*(C3:E3=A3))*
(COUNTIF(C3:E3,A3)=1),"Y","N")
我要如何Keep公式一樣抓取C$2:E$2的資料而不變呢?
2.
https://imgur.com/a/KipCrmI
如果填錯的數字為3 要如何顯示為N呢?
3.
https://imgur.com/a/xtDV5BA
這個日期,公式要怎麼改才能自動抓取儲存格中的日期?
再麻煩大大解惑,一樣600P~第一位
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 223.136.199.61 (臺灣)
※ 文章網址: https://www.ptt.cc/bbs/Office/M.1592047170.A.088.html
→
06/13 19:30,
3年前
, 1F
06/13 19:30, 1F
→
06/13 19:31,
3年前
, 2F
06/13 19:31, 2F
→
06/13 19:36,
3年前
, 3F
06/13 19:36, 3F
→
06/13 19:39,
3年前
, 4F
06/13 19:39, 4F
→
06/13 19:39,
3年前
, 5F
06/13 19:39, 5F
→
06/13 22:32,
3年前
, 6F
06/13 22:32, 6F
→
06/13 22:38,
3年前
, 7F
06/13 22:38, 7F
→
06/13 22:39,
3年前
, 8F
06/13 22:39, 8F
→
06/13 22:40,
3年前
, 9F
06/13 22:40, 9F
→
06/13 22:49,
3年前
, 10F
06/13 22:49, 10F
→
06/13 22:52,
3年前
, 11F
06/13 22:52, 11F
→
06/13 22:53,
3年前
, 12F
06/13 22:53, 12F
→
06/13 22:55,
3年前
, 13F
06/13 22:55, 13F
→
06/13 23:00,
3年前
, 14F
06/13 23:00, 14F
→
06/13 23:03,
3年前
, 15F
06/13 23:03, 15F
→
06/13 23:08,
3年前
, 16F
06/13 23:08, 16F
→
06/13 23:13,
3年前
, 17F
06/13 23:13, 17F
→
06/13 23:13,
3年前
, 18F
06/13 23:13, 18F
→
06/14 00:16,
3年前
, 19F
06/14 00:16, 19F
→
06/14 00:18,
3年前
, 20F
06/14 00:18, 20F
→
06/14 00:19,
3年前
, 21F
06/14 00:19, 21F
→
06/14 00:21,
3年前
, 22F
06/14 00:21, 22F
→
06/14 00:37,
3年前
, 23F
06/14 00:37, 23F