[算表] 在指定範圍內輸入特定的數字

[abc1234586 (ＡＢＣ)]

軟體:EXCEL

版本:2010

輸入區域──
     A   B   C
1  60%   3   5
2 100%   7   9
3  60%  10  12
4 100%  14  16
5  60%  17  18
6 100%  19  20

產生區域──
      D
 1
 2
 3  60%
 4  60%
 5  60%
 6
 7 100%
 8 100%
 9 100%
10  60%
11  60%
12  60%


如何藉由在D輸入公式來產生A~C所指定的內容呢

謝謝！

--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 61.231.188.129
※ 文章網址: https://www.ptt.cc/bbs/Office/M.1504246791.A.856.html
推 windknife18: =IF(SUM((ROW()>=$B$1:$B$100)*(ROW()<=$C$1:$C$100)
→ windknife18: =0,"",INDEX(A:A,SUM((ROW()>=$B$1:$B$100)*
→ windknife18: (ROW()<=$C$1:$C$100)*(ROW($1:$100)))))
→ windknife18: 輸入完按Ctrl+Shift+Enter 結束
→ abc1234586: 喔喔喔喔喔 謝謝！
→ abc1234586: 剛剛看到括號不對 是要多一個括號在前面那組陣列後面
→ abc1234586: 嗎
→ soyoso: =IFERROR(IF((VLOOKUP(ROW(),B:C,2)>=ROW())*(MAX(C:C)>=
→ soyoso: ROW()),INDEX(A:A,MATCH(ROW(),B:B)),""),"")
→ soyoso: https://i.imgur.com/HxcV1cm
→ abc1234586: 有了！感恩！！