[算表] 在固定範圍內取代空白儲存格為某數值
軟體:EXCEL
版本:2003
如題
假如有10列範圍
其中只有幾百格有文字
其他空白處都要填上不使用
請問這該用和函數達成呢？
謝謝！
--
▉▊◤ ◥ ▁▂▁ ├┤ ◤ ╮ ◥▎▏
▊◤ ＼ ⊙ ◢ ▁▂▁◆ ◆ ▇ ⊙ ︵ ◥▎
▊ ●◆──◆ 巛◆ ╰╯ ╣ ◆─◆) ▎
▊◣ ／ ⊙ ◥ ▇▆▅▄ ◆██████▁ ⊙ ︶ ◢▎
▉▊◣ ◢ ▇▆▅▆ ◣ ╯ ◢▎▏
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 221.169.204.126
※ Houcc:轉錄至看板 ask 04/17 22:12
推
04/17 22:50, , 1F
04/17 22:50, 1F
→
04/17 22:52, , 2F
04/17 22:52, 2F
→
04/17 22:59, , 3F
04/17 22:59, 3F
→
04/17 23:36, , 4F
04/17 23:36, 4F
→
04/17 23:38, , 5F
04/17 23:38, 5F
→
04/17 23:38, , 6F
04/17 23:38, 6F
→
04/18 00:05, , 7F
04/18 00:05, 7F
推
04/18 03:12, , 8F
04/18 03:12, 8F
→
04/18 03:15, , 9F
04/18 03:15, 9F
→
04/18 20:11, , 10F
04/18 20:11, 10F
→
04/18 23:01, , 11F
04/18 23:01, 11F
→
04/18 23:04, , 12F
04/18 23:04, 12F
→
04/18 23:04, , 13F
04/18 23:04, 13F
→
04/18 23:05, , 14F
04/18 23:05, 14F
→
04/18 23:05, , 15F
04/18 23:05, 15F
→
04/18 23:50, , 16F
04/18 23:50, 16F
Office 近期熱門文章
PTT數位生活區 即時熱門文章
