当前位置：首页 → 问答吧 → 求简化，求简化，谢谢！

求简化，求简化，谢谢！

时间：2011-08-07

来源：互联网

=IF(IF(IF(B2=0,"",COUNTA(B2))="","",IF(B2=0,"",COUNTA(B2))&"、"&$A2&B2&"；")="","", IF(IF(B2=0,"",COUNTA(B2))="","",IF(B2=0,"",COUNTA(B2))&"、"&$A2&B2&"；")&"
")&IF(IF(IF(B3=0,"",COUNTA(B$2:B3))="","", IF(B3=0,"",COUNTA(B$2:B3))&"、"&$A3&B3&"；")="","",IF(IF(B3=0,"",COUNTA(B$2:B3))="","", IF(B3=0,"",COUNTA(B$2:B3))&"、"&$A3&B3&"；")&"
")&IF(IF(IF(B4=0,"",COUNTA(B$2:B4))="","", IF(B4=0,"",COUNTA(B$2:B4))&"、"&$A4&B4&"；")="","",IF(IF(B4=0,"",COUNTA(B$2:B4))="","", IF(B4=0,"",COUNTA(B$2:B4))&"、"&$A4&B4&"；")&"
")&IF(IF(IF(B5=0,"",COUNTA(B$2:B5))="","", IF(B5=0,"",COUNTA(B$2:B5))&"、"&$A5&B5&"；")="","",IF(IF(B5=0,"",COUNTA(B$2:B5))="","", IF(B5=0,"",COUNTA(B$2:B5))&"、"&$A5&B5&"；")&"
")&IF(IF(IF(B6=0,"",COUNTA(B$2:B6))="","", IF(B6=0,"",COUNTA(B$2:B6))&"、"&$A6&B6&"；")="","",IF(IF(B6=0,"",COUNTA(B$2:B6))="","", IF(B6=0,"",COUNTA(B$2:B6))&"、"&$A6&B6&"；")&"
")&IF(IF(IF(B7=0,"",COUNTA(B$2:B7))="","", IF(B7=0,"",COUNTA(B$2:B7))&"、"&$A7&B7&"；")="","",IF(IF(B7=0,"",COUNTA(B$2:B7))="","", IF(B7=0,"",COUNTA(B$2:B7))&"、"&$A7&B7&"；")&"
")&IF(IF(IF(B8=0,"",COUNTA(B$2:B8))="","", IF(B8=0,"",COUNTA(B$2:B8))&"、"&$A8&B8&"；")="","",IF(IF(B8=0,"",COUNTA(B$2:B8))="","", IF(B8=0,"",COUNTA(B$2:B8))&"、"&$A8&B8&"；")&"
")&IF(IF(IF(B9=0,"",COUNTA(B$2:B9))="","", IF(B9=0,"",COUNTA(B$2:B9))&"、"&$A9&B9&"；")="","",IF(IF(B9=0,"",COUNTA(B$2:B9))="","", IF(B9=0,"",COUNTA(B$2:B9))&"、"&$A9&B9&"；")&"
")&IF(IF(IF(B10=0,"",COUNTA(B$2:B10))="","", IF(B10=0,"",COUNTA(B$2:B10))&"、"&$A10&B10&"；")="","",IF(IF(B10=0,"",COUNTA(B$2:B10))="","", IF(B10=0,"",COUNTA(B$2:B10))&"、"&$A10&B10&"；")&"
")&IF(IF(IF(B11=0,"",COUNTA(B$2:B11))="","", IF(B11=0,"",COUNTA(B$2:B11))&"、"&$A11&B11&"；")="","",IF(IF(B11=0,"",COUNTA(B$2:B11))="","", IF(B11=0,"",COUNTA(B$2:B11))&"、"&$A11&B11&"；")&"
")&IF(IF(IF(B12=0,"",COUNTA(B$2:B12))="","", IF(B12=0,"",COUNTA(B$2:B12))&"、"&$A12&B12&"；")="","",IF(IF(B12=0,"",COUNTA(B$2:B12))="","", IF(B12=0,"",COUNTA(B$2:B12))&"、"&$A12&B12&"；")&"
")&IF(IF(IF(B13=0,"",COUNTA(B$2:B13))="","", IF(B13=0,"",COUNTA(B$2:B13))&"、"&$A13&B13&"；")="","",IF(IF(B13=0,"",COUNTA(B$2:B13))="","", IF(B13=0,"",COUNTA(B$2:B13))&"、"&$A13&B13&"；")&"
")

作者: typ19871231 发布时间: 2011-08-07

这种问题要结合具体内容吧。

作者: lstxyzh 发布时间: 2011-08-07

似乎是有条件合并单元格内容将工作簿压缩后发过来看看没有附件不好解决问题

作者: yangrongguan 发布时间: 2011-08-07

这种公式没人有足够的耐心看完，直接传附件，说要求，做示例

作者: 一剑惊心发布时间: 2011-08-07