EXCEL条件合并公式设置
答案:2 悬赏:0 手机版
解决时间 2021-11-30 19:21
- 提问者网友：雾里闻花香
- 2021-11-30 04:01
EXCEL条件合并公式设置
最佳答案
- 五星知识达人网友：持酒劝斜阳
- 2021-11-30 04:44
D2中输入公式：
=IF(SUM(A2:C2)=0,"结束",IF(A2,$A$1&",","")&IF(B2,$B$1&",","")&IF(C2,$C$1,""))
下拉。追答要完美逗号的话，公式修改如下：
=IF(SUM(A5:C5)=0,"结束",IF(A5,$A$1&IF(SUM(B5:C5)=0,"",","),"")&IF(B5,$B$1&IF(C5,",",""),"")&IF(C5,$C$1,""))
=IF(SUM(A2:C2)=0,"结束",IF(A2,$A$1&",","")&IF(B2,$B$1&",","")&IF(C2,$C$1,""))
下拉。追答要完美逗号的话，公式修改如下：
=IF(SUM(A5:C5)=0,"结束",IF(A5,$A$1&IF(SUM(B5:C5)=0,"",","),"")&IF(B5,$B$1&IF(C5,",",""),"")&IF(C5,$C$1,""))
全部回答
- 1楼网友：不甚了了
- 2021-11-30 06:22
见图 首先在表格的最上方 插入一行 作为辅助行 左边插入一空列 （隐藏）……
顶端行 输入公式
B1 =IF(B2="",A1,B2) 右拉……做完之后 可以隐藏该行……
W7 =SUMPRODUCT(($B$1:$U$1=$V7)*($B$3:$U$3=W$6)*$B$4:$U$4) 验证……追问是按照图片做的么，，我是菜鸟，有点看不懂
顶端行 输入公式
B1 =IF(B2="",A1,B2) 右拉……做完之后 可以隐藏该行……
W7 =SUMPRODUCT(($B$1:$U$1=$V7)*($B$3:$U$3=W$6)*$B$4:$U$4) 验证……追问是按照图片做的么，，我是菜鸟，有点看不懂
我要举报
如以上问答信息为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！
大家都在看
推荐资讯