软件: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所指定的内容呢
谢谢！

=IF(SUM((ROW()>=$B$1:$B$100)*(ROW()<=$C$1:$C$100)=0,"",INDEX(A:A,SUM((ROW()>=$B$1:$B$100)*(ROW()<=$C$1:$C$100)*(ROW($1:$100)))))输入完按Ctrl+Shift+Enter 结束

喔喔喔喔喔 谢谢！刚刚看到括号不对 是要多一个括号在前面那组阵列后面吗

=IFERROR(IF((VLOOKUP(ROW(),B:C,2)>=ROW())*(MAX(C:C)>=ROW()),INDEX(A:A,MATCH(ROW(),B:B)),""),"")https://i.imgur.com/HxcV1cm

有了！感恩！！