求a列中合并单元格的个数

legend_chen

<br /><br /><BR>5个BB

hai

<p>=SUM(--(FREQUENCY(MATCH(LOOKUP(ROW(A1:A15),IF(A1:A15&lt;&gt;"",ROW(A1:A15)),A1:A15),LOOKUP(ROW(A1:A15),IF(A1:A15&lt;&gt;"",ROW(A1:A15)),A1:A15),0),MATCH(LOOKUP(ROW(A1:A15),IF(A1:A15&lt;&gt;"",ROW(A1:A15)),A1:A15),LOOKUP(ROW(A1:A15),IF(A1:A15&lt;&gt;"",ROW(A1:A15)),A1:A15),0))&gt;1))</p><p>数组!</p>

一剑惊心

<div class="quote" twffan="done"><b>以下是引用<i>hai</i>在2008-2-17 20:51:00的发言：</b><br/><p>=SUM(--(FREQUENCY(MATCH(LOOKUP(ROW(A1:A15),IF(A1:A15&lt;&gt;"",ROW(A1:A15)),A1:A15),LOOKUP(ROW(A1:A15),IF(A1:A15&lt;&gt;"",ROW(A1:A15)),A1:A15),0),MATCH(LOOKUP(ROW(A1:A15),IF(A1:A15&lt;&gt;"",ROW(A1:A15)),A1:A15),LOOKUP(ROW(A1:A15),IF(A1:A15&lt;&gt;"",ROW(A1:A15)),A1:A15),0))&gt;1))</p><p>数组!</p></div><p>似乎不对啊</p>

tca

<div class="msgheader">QUOTE:</div><div class="msgborder"><b>以下是引用<i>hai</i>在2008-2-17 20:51:00的发言：</b><br/><p>=SUM(--(FREQUENCY(MATCH(LOOKUP(ROW(A1:A15),IF(A1:A15&lt;&gt;"",ROW(A1:A15)),A1:A15),LOOKUP(ROW(A1:A15),IF(A1:A15&lt;&gt;"",ROW(A1:A15)),A1:A15),0),MATCH(LOOKUP(ROW(A1:A15),IF(A1:A15&lt;&gt;"",ROW(A1:A15)),A1:A15),LOOKUP(ROW(A1:A15),IF(A1:A15&lt;&gt;"",ROW(A1:A15)),A1:A15),0))&gt;1))</p><p>数组!</p></div><p>举一反三的能力&nbsp; 很强啊</p>[em17][em17][em17][em17][em17]

hai

<div class="msgheader">QUOTE:</div><div class="msgborder"><b>以下是引用<i>一剑惊心</i>在2008-2-17 20:53:00的发言：</b><br/><div class="quote" twffan="done"><b>以下是引用<i>hai</i>在2008-2-17 20:51:00的发言：</b><br/><p>=SUM(--(FREQUENCY(MATCH(LOOKUP(ROW(A1:A15),IF(A1:A15&lt;&gt;"",ROW(A1:A15)),A1:A15),LOOKUP(ROW(A1:A15),IF(A1:A15&lt;&gt;"",ROW(A1:A15)),A1:A15),0),MATCH(LOOKUP(ROW(A1:A15),IF(A1:A15&lt;&gt;"",ROW(A1:A15)),A1:A15),LOOKUP(ROW(A1:A15),IF(A1:A15&lt;&gt;"",ROW(A1:A15)),A1:A15),0))&gt;1))</p><p>数组!</p></div><p>似乎不对啊</p></div><p></p>&nbsp;&nbsp;&nbsp; 哪里不对呢?[em04]

Excel教程

{=SUM((OFFSET($A$2:$A$15,1,)="")*(A2:A15&lt;&gt;"")*1)}

hai

<div class="msgheader">QUOTE:</div><div class="msgborder"><b>以下是引用<i>Excel教程</i>在2008-2-17 22:21:00的发言：</b><br/>{=SUM((OFFSET($A$2:$A$15,1,)="")*(A2:A15&lt;&gt;"")*1)}</div><p>&nbsp;&nbsp; 简单,学习了!</p>

zhaoxiaofeng

<p>kan kan&nbsp; </p>

[此贴子已经被作者于2008-2-18 9:07:42编辑过]

一剑惊心

<p>不知是我操作错误还是别的原因？反正似乎答案不是很准确！</p><p>S：hai的公式是否实时更新结果的？</p><p><img src="http://freep.cn/p.aspx?u=v20__p_0802180833566188_0.gif" border="0" twffan="done" alt=""/></p>

联想

<div class="msgheader">QUOTE:</div><div class="msgborder"><b>以下是引用<i>Excel教程</i>在2008-2-17 22:21:00的发言：</b><br/>{=SUM((OFFSET($A$2:$A$15,1,)="")*(A2:A15&lt;&gt;"")*1)}</div><p>似乎也不对, 我改变a列的合并单元格,结果就比实际要小1个.</p>