再次求助，多条件取数（简化了表）

ych9999

再次求助，多条件取数（简化了表）

丢丢表格

用透视做呀.

山菊花

VBA方法，供参考。

hbzql

B3=IFERROR(INDEX(表1!$B$2:$E$33,SMALL(IF(IF(表1!$D$2:$D$33>=1000,IF(MATCH(表1!$A$2:$A$33&表1!$E$2:$E$33&表1!$C$2:$C$33,表1!$A$2:$A$33&表1!$E$2:$E$33&表1!$C$2:$C$33,0)=ROW($1:$32),表1!$A$2:$A$33,""),"")=A3,ROW($1:$32),2^8),COUNTIF($A$3:A3,A3)),4),"")下拉

C3=IFERROR(INDEX(表1!$B$2:$E$33,SMALL(IF(IF(表1!$D$2:$D$33>=1000,IF(MATCH(表1!$A$2:$A$33&表1!$E$2:$E$33&表1!$C$2:$C$33,表1!$A$2:$A$33&表1!$E$2:$E$33&表1!$C$2:$C$33,0)=ROW($1:$32),表1!$A$2:$A$33,""),"")=A3,ROW($1:$32),2^8),COUNTIF($A$3:A3,A3)),2),"")下拉


D3=SUM(IF($A3&$B3&$C3&LEFT(D$2,LEN(D$2)-1)=表1!$A$2:$A$33&表1!$E$2:$E$33&表1!$C$2:$C$33&表1!$B$2:$B$33,表1!$D$2:$D$33,0))右拉下拉

zpy2

select [标号],[代码],[编号],group_concat(distinct(case when 列标签='12' then 数据 else null end)) as '12',group_concat(distinct(case when 列标签='1' then 数据 else null end)) as '1',group_concat(distinct(case when 列标签='2' then 数据 else null end)) as '2' from (select [标号],[代码],[编号],列标签,sum(数据) 数据 from input2 group by [标号],[代码],[编号],列标签) group by [标号],[代码],[编号]