公式处理

天涯论剑

D列是辅助列，E列是想要的结果，都运用了公式，需求是不要做辅助列就可以做出E列的结果，用函数一次性做出来

机智

=INDEX(C:C,IF(ROW()<=MATCH("座",$C$1:$C4)+INT(COUNTIF(D:D,MATCH("座",$C$1:$C4)))/2,D4,MATCH("座",$C$1:$C4)+MATCH("座",$C$1:$C4)=MATCH("座",OFFSET(C$1:c4,,,ROW(1:30)),)))
好像是错的，我再改改

天涯论剑

机智 发表于 2023-6-27 22:55
=INDEX(C:C,IF(ROW()

感谢，麻烦大佬在看看

tchh666

1. =INDEX(C:C,MATCH("々",C$1:C4)+SUM(N(LOOKUP(ROW($4:$33),ROW($4:$33)/($C$4:$C$33>0))=MATCH("々",C$1:C4)))*(ROW()>=MATCH("々",C$1:C4)+SUM(N(LOOKUP(ROW($4:$33),ROW($4:$33)/($C$4:$C$33>0))=MATCH("々",C$1:C4)))/2))

复制代码

jivy1212

1. =IF(ROW()-MATCH("座",$C$1:C4)>MATCH("*",C5:$C$33,),VLOOKUP("*",C4:C33,1,),LOOKUP("座",$C$4:C4))

复制代码

jivy1212

1. =LOOKUP(,0/FREQUENCY(0,(($C$4:$C$33<>"")*ROW($4:$33)-ROW())^2),$C$4:$C$33)

复制代码

再打破换个海鲜大法。