<div class="msgheader">QUOTE:</div><div class="msgborder"><b>以下是引用<i>hai</i>在2008-2-19 3:38:00的发言:</b><br/><p>高僧做了第一题,哪我试下第二题吧!</p><p>定义名称=--(MID(Sheet1!$A$1,ROW(INDIRECT("1:"&LEN(Sheet1!$A$1))),1)=MID(Sheet1!$A$1,ROW(INDIRECT("2:"&LEN(Sheet1!$A$1)+1)),1))</p><p>=MAX(FREQUENCY(IF(AAA,ROW(INDIRECT("1:"&LEN($A$1)))),IF(1-AAA,ROW(INDIRECT("1:"&LEN($A$1))))))+1</p><p>=INDEX(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1),MATCH(B1-1,FREQUENCY(IF(AAA,ROW(INDIRECT("1:"&LEN($A$1)))),IF(1-AAA,ROW(INDIRECT("1:"&LEN($A$1))))),0)+B1-2)</p><p>不知道对不对,请指教了[em04]</p></div><p></p>看一下第二个例子, 只符合第一个例子我也做出来了. |