EXCEL,如何让满足符合的条件合并到指定单元格?有图,高手请进!_百度知 ...答:D2=B2&IF(ISERROR(VLOOKUP(C2,C3:D12,2,0)),"",","&VLOOKUP(C2,C3:D12,2,0))向下复制 G1=MIN(A2:A12)设置为时间格式 G2=MAX(A2:A12)设置为时间格式 G3=VLOOKUP(F3,$C$2:$D$12,2,0)向下复制
excel表格按条件合并问题答:sheet1 K2=A2&B2&C2向下复制 L2=IF(COUNTIF(K$2:K2,K2)=1,MAX(L$1:L1)+1,"")向下复制 sheet2 A2=IF(ISERROR(VLOOKUP(ROW(A1),IF({1,0},Sheet1!$L$2:$L$10000,Sheet1!A$2:A$10000),2,0)),"",VLOOKUP(ROW(A1),IF({1,0},Sheet1!$L$2:$L$10000,Sheet1!A$2:A$...