[算表] 我的query遇到小難題
軟體: 試算表
版本: Google
http://i.imgur.com/uXXEdks.jpg
我query目前是抓F欄含有@符號的整欄位,是沒有問題可以正常抓資料,現在想另開一個
工作表,函數一樣那樣key,前面一樣,只是後面改 where D contains'@' ,但是卻沒有
出現數據?
我的要抓的數據表的D欄內格子確實有@符號,但是就是不會幫我抓出來
請問哪裡出問題了,麻煩大大教教我
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 101.139.84.64
※ 文章網址: https://www.ptt.cc/bbs/Office/M.1493644910.A.5EB.html
→
05/01 22:14, , 1F
05/01 22:14, 1F
→
05/02 16:29, , 2F
05/02 16:29, 2F
→
05/02 16:37, , 3F
05/02 16:37, 3F
→
05/02 17:32, , 4F
05/02 17:32, 4F
→
05/02 18:16, , 5F
05/02 18:16, 5F
→
05/02 18:16, , 6F
05/02 18:16, 6F
→
05/02 18:18, , 7F
05/02 18:18, 7F
→
05/02 18:20, , 8F
05/02 18:20, 8F
→
05/02 18:21, , 9F
05/02 18:21, 9F
→
05/02 18:22, , 10F
05/02 18:22, 10F
→
05/02 18:23, , 11F
05/02 18:23, 11F
→
05/02 18:24, , 12F
05/02 18:24, 12F
→
05/02 18:25, , 13F
05/02 18:25, 13F
→
05/02 18:26, , 14F
05/02 18:26, 14F
→
05/02 18:28, , 15F
05/02 18:28, 15F
→
05/02 18:29, , 16F
05/02 18:29, 16F
→
05/02 18:38, , 17F
05/02 18:38, 17F