EXEL2007中如何快速汇总姓名相同的不同行中其他单元格的数据到一行(表...答:2007版公式 =IFERROR(LOOKUP("丫",IF($A$2:$A$8=$A12,OFFSET($A$2,,MATCH(B$11,$B$2:$F$2,),7))),"")2003版公式 =IF(ISNA(LOOKUP("丫",IF($A$2:$A$8=$A12,OFFSET($A$2,,MATCH(B$11,$B$2:$F$2,),7))),"",LOOKUP("丫",IF($A$2:$A$8=$A12,OFFSET($A...