Excel知识兴趣点五十九:如何制作图表(数学之美),方法参考该帖说明:
http://150.48.48.12/bbs/viewthread.php?tid=17605&extra=page%3D1
Excel知识兴趣点六十:如何显示录入的内容:方法参考该帖说明:
http://150.48.48.12/bbs/viewthread.php?tid=17611&extra=page%3D1
方法一:坛友seaxin的思路:
D2=INDEX(A2:A100,COUNTA(A2:A100),1)
D2=OFFSET(A2,COUNTA(A2:A100)-1,0,1,1)
方法二:
D2=OFFSET($A$1,COUNTA(A2:A100)-1,0,1,1)