遇到不同的，空一行，繼續輸出[已開帖]

心正意诚身修

今天論壇題少，，再找一個練習題，給高們手玩玩。。然後向高手們學習。
沒人做了。。開帖，感謝四位老師的參與

心正意诚身修

BAKSY老师答案：=INDEX(A:A,MOD(SMALL(IF({1,0},ROW(A$1:A$13)*101,IF((A$1:A$13<>A$2:A$14),ROW(A$1:A$13)*100+90)),ROW(A1)),100))&""
砂海老师答案：
=INDEX(A:A,IF(MOD(SMALL(IF({1,0},ROW($A$1:$A$13),ROW($A$1:$A$13)+IF($A$1:$A$13<>$A$2:$A$14,0.5,65536)),ROW(A1)),1)=0,SMALL(IF({1,0},ROW($A$1:$A$13),ROW($A$1:$A$13)+IF($A$1:$A$13<>$A$2:$A$14,0.5,65536)),ROW(A1)),65536))&""
王春林老師答案
=IF(ROW()>1,IF(AND(INDIRECT("r[-1]c",)<>"",OR(IF(A$1:A$13<>A$2:A$14,ROW($2:$14))=ROW()-COUNTBLANK(INDIRECT("C1:C"&ROW()-1)))),"",INDIRECT("A"&ROW()-COUNTBLANK(INDIRECT("C1:C"&ROW()-1)))),A1)此解不通用
暢神提供
=INDEX(A:A,SMALL({99,0.1}^(A1:B18=A2:B19)+ROW(),ROW())&0)&""  18行的區域 數組
=INDEX(A:A,MOD(SMALL(ROW($1:13)*101+((A$1:A13=A$2:A14)/1%%+14)*{0,1},ROW()),50))&""

baksy

减了几个字符~

砂海

开个火车
=INDEX(A:A,IF(MOD(SMALL(IF({1,0},ROW($A$1:$A$13),ROW($A$1:$A$13)+IF($A$1:$A$13<>$A$2:$A$14,0.5,65536)),ROW(A1)),1)=0,SMALL(IF({1,0},ROW($A$1:$A$13),ROW($A$1:$A$13)+IF($A$1:$A$13<>$A$2:$A$14,0.5,65536)),ROW(A1)),65536))&""
数组三键

xiaoni

占位

tt0203

函数800题 罚款
http://www.excelpx.com/thread-372331-1-1.html
15楼最后一张照片

chunlin1wang

1. =IF(ROW()>1,IF(AND(INDIRECT("r[-1]c",)<>"",OR(IF(A$1:A$13<>A$2:A$14,ROW($2:$14))=ROW()-COUNTBLANK(INDIRECT("C1:C"&ROW()-1)))),"",INDIRECT("A"&ROW()-COUNTBLANK(INDIRECT("C1:C"&ROW()-1)))),A1)

复制代码