<div class="msgheader">QUOTE:</div><div class="msgborder"><b>以下是引用<i>Luckyguy2008</i>在2007-11-1 22:30:40的发言:</b><br/>=INDEX(A:A,MOD(SMALL(IF({1,0},ROW(A1:A14)*1001,IF(MATCH(A1:A14,A1:A14)=ROW(A1:A14),ROW(A1:A14)*1000+100)),ROW(INDIRECT("1:"&SUM(1/COUNTIF(A1:A14,A1:A14))-1+ROWS(A1:A14)))),1000))&""<br/></div><p>很好的思路! </p><p>不用MATCH函数公式会短点。 </p><p>=T(OFFSET($A$1,RIGHT(SMALL(IF({1,0},ROW($A$1:$A$14)*1001,IF($A$1:$A$14<>$A$2:$A$15,ROW($A$1:$A$14)*1000+99)),ROW(INDIRECT("1:"&SUM(1/COUNTIF($A$1:$A$14,$A$1:$A$14))-1+ROWS($A$1:$A$14)))),2)-1,))</p>
[此贴子已经被作者于2007-11-2 14:33:00编辑过] |