excel函数处理数据~

通用软件么

将左侧表格按照受理网点所对应的业务名称和处理成功业务量做成红色模板表的格式

hcm19522

E2{=IFERROR(INDEX(A:A,TEXT(MIN(IF(COUNTIF(E$1:E1,A$2:A$799)=0,ROW(A$2:A$799))),"0;;")),"")

F2=IF(SUMPRODUCT(($A$2:$A$799=$E3)*($B$2:$B$799=OFFSET($D$1,,MAX(INT(COLUMN(B2)/2)*2)))*$C$2:$C$799)>0,IF(MOD(COLUMN(A2),2)=1,F$1,SUMIFS($C$2:$C$799,$A$2:$A$799,$E3,$B$2:$B$799,E3)),"")