接力赛：返回题目及对应的答案

一剑惊心

<p>155个字符普通公式从C1开始下拉</p><p>=IF(ROW()&gt;COUNTIF(A:A,"A*"),"",INDEX(A:A,MATCH(ROW()&amp;"*",A:A,))&amp;MID(INDEX(A:A,CODE(RIGHT(INDEX(A:A,MATCH(ROW()&amp;"*",A:A,))))-64+MATCH(ROW()&amp;"*",A:A,)),2,9))</p>

aa123456aa

<p>194字符</p><p>=INDEX(A:A,--TEXT(MAX(ROW($1:$35)*(LEFT(A$1:A$35)=ROW()&amp;"")),"0;;!3!6"))&amp;MID(LOOKUP(SMALL(ROW($1:$35)+CODE(IF(LEN(TEXT(LEFT(A$1:A$35),"0;;;")),RIGHT(A$1:A$35),"翁"))-64,ROW()),ROW(A:A),A:A),2,99)</p>

aa123456aa

<div class="msgheader">QUOTE:</div><div class="msgborder"><b>以下是引用<i>一剑惊心</i>在2010-8-1 20:17:00的发言：</b><br/><p>155个字符普通公式从C1开始下拉</p><p>=IF(ROW()&gt;COUNTIF(A:A,"A*"),"",INDEX(A:A,MATCH(ROW()&amp;"*",A:A,))&amp;MID(INDEX(A:A,CODE(RIGHT(INDEX(A:A,MATCH(ROW()&amp;"*",A:A,))))-64+MATCH(ROW()&amp;"*",A:A,)),2,9))</p></div><p>也太快了吧</p>[em01]

wjh619993018

<div class="msgheader">QUOTE:</div><div class="msgborder"><b>以下是引用<i>aa123456aa</i>在2010-8-1 20:14:00的发言：</b><br/><p>205字符 区域数组</p><p>=LOOKUP(SMALL(IF(--TEXT(LEFT(A1:A35),"1;;;!0"),ROW(1:35),99),ROW(1:35)),ROW(A:A),A:A)&amp;MID(LOOKUP(SMALL(ROW(1:35)+CODE(IF(LEN(TEXT(LEFT(A1:A35),"0;;;")),RIGHT(A1:A35),"翁"))-64,ROW(1:35)),ROW(A:A),A:A),2,99)</p></div><p>既然有了约定，一个公式下拉，这个就不算了</p>

[此贴子已经被作者于2010-8-1 20:48:37编辑过]

TTTTT

<p>144</p><p>=IF(ROW()&gt;COUNTIF(A:A,"A*"),"",VLOOKUP(ROW()&amp;"*",A:A,1,)&amp;MID(OFFSET($A$1,CODE(RIGHT(VLOOKUP(ROW()&amp;"*",A:A,1,)))-65+MATCH(ROW()&amp;"*",A:A,),),2,9))</p>

TTTTT

<p>141</p><p>=IF(ROW()&gt;COUNTIF(A:A,"A*"),"",VLOOKUP(ROW()&amp;"*",A:A,1,)&amp;MID(INDEX(A:A,CODE(RIGHT(VLOOKUP(ROW()&amp;"*",A:A,1,)))-64+MATCH(ROW()&amp;"*",A:A,)),2,9))</p>

dengyf

<p>附件不好下载，凭公式试着精减</p><p>=IF(COUNTIF(A:A,ROW()&amp;"*"),VLOOKUP(ROW()&amp;"*",A:A,1,)&amp;MID(INDEX(A:A,CODE(RIGHT(VLOOKUP(ROW()&amp;"*",A:A,1,)))-64+MATCH(ROW()&amp;"*",A:A,)),2,9),"")</p>

[此贴子已经被兰色幻想于2010-8-3 11:19:30编辑过]

wjh619993018

<p>17楼140字符</p>

小_笨_笨

<p>=IF(ROW()&gt;7,"",VLOOKUP(ROW()&amp;"*",A:A,1,)&amp;MID(INDEX(A:A,CODE(RIGHT(VLOOKUP(ROW()&amp;"*",A:A,1,)))-64+MATCH(ROW()&amp;"*",A:A,)),2,9))</p><p>既然表中啥都不能改，就这样吧</p>

wjh619993018

<div class="msgheader">QUOTE:</div><div class="msgborder"><b>以下是引用<i>小_笨_笨</i>在2010-8-4 11:27:00的发言：</b><br/><p>=IF(ROW()&gt;7,"",VLOOKUP(ROW()&amp;"*",A:A,1,)&amp;MID(INDEX(A:A,CODE(RIGHT(VLOOKUP(ROW()&amp;"*",A:A,1,)))-64+MATCH(ROW()&amp;"*",A:A,)),2,9))</p><p>既然表中啥都不能改，就这样吧</p></div><p>这个就别算数了，好吗？</p>