[算表] excel 下拉選單 問題
各位大大你們好
我有個問題要請教一下
我的表單是類似這樣
每個同學上的課不一樣
所以沒上的課就不會有成績
我在下拉選單選了名字後
黃色區域可出現有成績的科目
旁邊是該科目的成績
請問我該如何寫才能跳過空白成績的項目
感謝各位指導
-----
Sent from JPTT on my Asus ASUS_Z008D.
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 114.35.113.32
※ 文章網址: https://www.ptt.cc/bbs/Office/M.1486484026.A.68A.html
→
02/08 00:30, , 1F
02/08 00:30, 1F
→
02/08 00:58, , 2F
02/08 00:58, 2F
→
02/08 01:21, , 3F
02/08 01:21, 3F
→
02/08 01:21, , 4F
02/08 01:21, 4F
→
02/08 01:28, , 5F
02/08 01:28, 5F
→
02/08 06:53, , 6F
02/08 06:53, 6F
→
02/08 06:56, , 7F
02/08 06:56, 7F
→
02/08 06:57, , 8F
02/08 06:57, 8F
→
02/08 07:00, , 9F
02/08 07:00, 9F
→
02/08 07:01, , 10F
02/08 07:01, 10F
→
02/08 07:01, , 11F
02/08 07:01, 11F
→
02/08 12:06, , 12F
02/08 12:06, 12F
→
02/08 12:06, , 13F
02/08 12:06, 13F
→
02/08 12:10, , 14F
02/08 12:10, 14F
→
02/08 12:10, , 15F
02/08 12:10, 15F
→
02/08 12:21, , 16F
02/08 12:21, 16F
→
02/08 12:50, , 17F
02/08 12:50, 17F
→
02/08 12:51, , 18F
02/08 12:51, 18F
→
02/08 12:52, , 19F
02/08 12:52, 19F
→
02/08 12:59, , 20F
02/08 12:59, 20F
→
02/08 13:00, , 21F
02/08 13:00, 21F
→
02/08 13:22, , 22F
02/08 13:22, 22F
→
02/08 13:31, , 23F
02/08 13:31, 23F
→
02/08 13:32, , 24F
02/08 13:32, 24F
→
02/08 16:03, , 25F
02/08 16:03, 25F
→
02/08 16:03, , 26F
02/08 16:03, 26F
→
02/08 16:13, , 27F
02/08 16:13, 27F
→
02/08 23:07, , 28F
02/08 23:07, 28F