L6输入=IF(SUM(COUNTIF(C6:G6,{"A","B","C"})),"A.B.C",SUM(L5)+1)公式下拉
i6=SUM(COUNTIF(C6:G6,{"A","B","C"}))向下填充
你的意思是,如果I列为0,按顺序写需要,如果大于0,“A.B.C”么?