同日同單位非空 判斷 (11248)

J2 {=IF(SUM(N(IF((E$2:E$1999=E2)*(F$2:I$1999<>""),COLUMN(A:D))=(F2:I2<>"")*COLUMN(A:D)))-COUNTIF(F2:I2,"<>"),"重複","")