每行數字均有出現 提出 (10084)

F1{=REPT(0,COUNT(FIND(0,A1:D1))=4)&SUBSTITUTE(SUM((MMULT(1-ISERR(FIND(ROW($1:$9),A1:D1)),{1;1;1;1})=4)*ROW($1:$9)*10^(9-ROW($1:$9))),0,)

另解{=MID(SUM(IFERROR(SMALL(IF(MMULT(1-ISERR(FIND(ROW($1:$10)-1,A1:D1)),{1;1;1;1})=4,ROW($1:$10)-1),ROW($1:$10))*10^-ROW($1:$10),)),3,9)