<div class="msgheader">QUOTE:</div><div class="msgborder"><b>以下是引用<i>小笨蛋</i>在2008-7-14 14:20:00的发言:</b><br/><div class="msgheader">QUOTE:</div><div class="msgborder"><b>以下是引用<i>doggie520</i>在2008-7-14 13:38:00的发言:</b><br/><p>学习一下吧......</p><p></p></div><p>实用不通用,在A15输入一个数据就会出错!</p></div><p>加判断纠正:</p><p>=IF(A15<>"",SUM(INDIRECT("C"&ROW(INDIRECT(ROW()&":"&MIN(IF(A$15:A16<>"",ROW($15:16)))*(ROW()<>15)+((SUM((A$15:A16<>"")*ROW($15:16))=0)+(ROW()=15))*16-1)))),"")</p>
[此贴子已经被作者于2008-7-15 12:33:06编辑过] |