求EXCEL公式,在线等!!

要求如图。
2024-12-15 16:29:08
推荐回答(1个)
回答1:

I1=IF(COUNTIF(C1:D1,"C")*COUNTIF(F1:G1,"D"),"D","")
J1=IF(I1="D","","C")
下拉I1:J1