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

wjh619993018 · 发表于 2010-8-1 16:46

严禁跟贴灌水，否则每贴扣罚20金币          1、 什么是接力赛？详见 好玩的竟赛模式：优化接力赛<a href="http://www.excelpx.com/forum.php?mod=viewthread&tid=136591" target="_blank">http://www.excelpx.com/forum.php?mod=viewthread&tid=136591</a>        2、本题目奖励基数为10，奖励系数为1.2，详细请见附表。        3、参与方式：下载附件然后对公式进行优化，如果你的公式式长度短于目前最短的公式长度，你就可以回贴提交公式（注明公式长度）        4、公式必须适用于2003版本        5、题目的具体要求见附件 奖励：<table cellspacing="0" cellpadding="0" width="201" border="0" style="WIDTH: 151pt; BORDER-COLLAPSE: collapse;"><colgroup><col width="72" style="WIDTH: 54pt;"></col><col></col><col width="129" style="WIDTH: 97pt; mso-width-source: userset; mso-width-alt: 4128;"></col><col></col></colgroup><tbody><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl23" width="72" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: silver;">基数</td><td class="xl23" align="right" width="129" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 97pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: silver;">10</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl22" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">第1棒</td><td class="xl22" align="right" xfmla="=ROUND(B1*1.2,)" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">12</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl22" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">第2棒</td><td class="xl22" align="right" xfmla="=ROUND(B2*1.2,)" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">14</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl22" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">第3棒</td><td class="xl22" align="right" xfmla="=ROUND(B3*1.2,)" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">17</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl22" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">第4棒</td><td class="xl22" align="right" xfmla="=ROUND(B4*1.2,)" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">20</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl22" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">第5棒</td><td class="xl22" align="right" xfmla="=ROUND(B5*1.2,)" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">24</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl22" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">第6棒</td><td class="xl22" align="right" xfmla="=ROUND(B6*1.2,)" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">29</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl22" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">第7棒</td><td class="xl22" align="right" xfmla="=ROUND(B7*1.2,)" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">35</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl22" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">第8棒</td><td class="xl22" align="right" xfmla="=ROUND(B8*1.2,)" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">42</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl22" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">第9棒</td><td class="xl22" align="right" xfmla="=ROUND(B9*1.2,)" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">50</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl22" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">第10棒</td><td class="xl22" align="right" xfmla="=ROUND(B10*1.2,)" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">60</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl22" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">第11棒</td><td class="xl22" align="right" xfmla="=ROUND(B11*1.2,)" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">72</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl22" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">第12棒</td><td class="xl22" align="right" xfmla="=ROUND(B12*1.2,)" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">86</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl22" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">第13棒</td><td class="xl22" align="right" xfmla="=ROUND(B13*1.2,)" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">103</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl22" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">第14棒</td><td class="xl22" align="right" xfmla="=ROUND(B14*1.2,)" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">124</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl22" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">第15棒</td><td class="xl22" align="right" xfmla="=ROUND(B15*1.2,)" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">149</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl22" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">第16棒</td><td class="xl22" align="right" xfmla="=ROUND(B16*1.2,)" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">179</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl22" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">第17棒</td><td class="xl22" align="right" xfmla="=ROUND(B17*1.2,)" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">215</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl22" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">第18棒</td><td class="xl22" align="right" xfmla="=ROUND(B18*1.2,)" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">258</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl22" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">第19棒</td><td class="xl22" align="right" xfmla="=ROUND(B19*1.2,)" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">310</td></tr><tr height="19" style="HEIGHT: 14.25pt;"><td class="xl22" height="19" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext 0.5pt solid; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 14.25pt; BACKGROUND-COLOR: transparent;">第20棒</td><td class="xl22" align="right" xfmla="=ROUND(B20*1.2,)" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext; BORDER-LEFT: windowtext; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;">372</td></tr></tbody></table>

[此贴子已经被兰色幻想于2010-8-1 17:02:24编辑过]

小_笨_笨 · 发表于 2010-8-1 17:17

346字符：=LEFT(INDEX(A:A,SMALL(IF(ISNUMBER(-LEFT(A$1:A$35)),ROW(A$1:A$35),99),ROW())),ABS(LEN(INDEX(A:A,SMALL(IF(ISNUMBER(-LEFT(A$1:A$35)),ROW(A$1:A$35),99),ROW())))-1))&INDEX(A:A,SMALL(IF(ISNUMBER(-LEFT(A$1:A$35)),ROW(A$1:A$35),99),ROW())+MATCH(RIGHT(INDEX(A:A,SMALL(IF(ISNUMBER(-LEFT(A$1:A$35)),ROW(A$1:A$35),99),ROW()))),{"A","B","C","D","E","F",""},))先占个位子再说

[此贴子已经被作者于2010-8-1 17:17:33编辑过]

小_笨_笨 · 发表于 2010-8-1 17:20

338字符：=LEFT(INDEX(A:A,SMALL(IF(ISNUMBER(-LEFT(A$1:A$35)),ROW($1:$35),99),ROW())),ABS(LEN(INDEX(A:A,SMALL(IF(ISNUMBER(-LEFT(A$1:A$35)),ROW($1:$35),99),ROW())))-1))&INDEX(A:A,SMALL(IF(ISNUMBER(-LEFT(A$1:A$35)),ROW($1:$35),99),ROW())+MATCH(RIGHT(INDEX(A:A,SMALL(IF(ISNUMBER(-LEFT(A$1:A$35)),ROW($1:$35),99),ROW()))),{"A","B","C","D","E","F",""},))再占个位子

皇太极 · 发表于 2010-8-1 17:29

334字符=LEFT(INDEX(A:A,SMALL(IF(1-ISERR(-LEFT(A$1:A$35)),ROW($1:$35),99),ROW())),ABS(LEN(INDEX(A:A,SMALL(IF(1-ISERR(-LEFT(A$1:A$35)),ROW($1:$35),99),ROW())))-1))&INDEX(A:A,SMALL(IF(1-ISERR(-LEFT(A$1:A$35)),ROW($1:$35),99),ROW())+MATCH(RIGHT(INDEX(A:A,SMALL(IF(1-ISERR(-LEFT(A$1:A$35)),ROW($1:$35),99),ROW()))),{"A","B","C","D","E","F",""},))

wyywym · 发表于 2010-8-1 17:55

329字符=LEFT(INDEX(A:A,SMALL(IF(1-ISERR(-LEFT(A$1:A$35)),ROW($1:$35),99),ROW())),LEN(INDEX(A:A,SMALL(IF(1-ISERR(-LEFT(A$1:A$35)),ROW($1:$35),35),ROW())))-1)&INDEX(A:A,SMALL(IF(1-ISERR(-LEFT(A$1:A$35)),ROW($1:$35),99),ROW())+MATCH(RIGHT(INDEX(A:A,SMALL(IF(1-ISERR(-LEFT(A$1:A$35)),ROW($1:$35),99),ROW()))),{"A","B","C","D","E","F",""},))

aa123456aa · 发表于 2010-8-1 18:19

244字符=IF(ROW()>MAX(--TEXT(LEFT(A$1:A$35),"0;;;!0")),"",INDEX(A:A,MAX(ROW($1:$35)*(LEFT(A$1:A$35)=ROW()&"")))&MID(INDEX(A:A,MAX(ROW($1:$35)*(LEFT(A$1:A$35)=ROW()&""))+FIND(RIGHT(INDEX(A:A,MAX(ROW($1:$35)*(LEFT(A$1:A$35)=ROW()&"")))),"ABCDEF")),2,99))

aa123456aa · 发表于 2010-8-1 19:21

238字符=IF(ROW()>MAX(--TEXT(LEFT(A$1:A$35),"0;;;!0")),"",INDEX(A:A,MAX(ROW($1:$35)*(LEFT(A$1:A$35)=ROW()&"")))&MID(INDEX(A:A,MAX(ROW($1:$35)*(LEFT(A$1:A$35)=ROW()&""))+CODE(RIGHT(INDEX(A:A,MAX(ROW($1:$35)*(LEFT(A$1:A$35)=ROW()&"")))))-64),2,99))

皇太极 · 发表于 2010-8-1 19:41

234字符=IF(ROW()>MAX(--TEXT(LEFT(A$1:A$35),"0;;;!0")),"",LOOKUP(99,FIND(ROW()&"",LEFT(A$1:A$35)),A$1:A$35)&MID(INDEX(A:A,MAX(ROW($1:$35)*(LEFT(A$1:A$35)=ROW()&""))+CODE(RIGHT(INDEX(A:A,MAX(ROW($1:$35)*(LEFT(A$1:A$35)=ROW()&"")))))-64),2,99))

皇太极 · 发表于 2010-8-1 20:13

230字符=IF(ROW()>MAX(--TEXT(LEFT(A$1:A$35),"0;;;!0")),"",LOOKUP(,0/(ROW()&""=LEFT(A$1:A$35)),A$1:A$35)&MID(INDEX(A:A,MAX(ROW($1:$35)*(LEFT(A$1:A$35)=ROW()&""))+CODE(RIGHT(INDEX(A:A,MAX(ROW($1:$35)*(LEFT(A$1:A$35)=ROW()&"")))))-64),2,99))

aa123456aa · 发表于 2010-8-1 20:14

205字符区域数组=LOOKUP(SMALL(IF(--TEXT(LEFT(A1:A35),"1;;;!0"),ROW(1:35),99),ROW(1:35)),ROW(A:A),A:A)&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)

		自动登录	找回密码
密码			注册

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

本帖子中包含更多资源