各單一數字乘積 找出最小數字 (14082)

D3{=IFERROR(MATCH(B3,TEXT(MID(TEXT(ROW($1:$4999),"0000"),1,1),"0;;1")*TEXT(MID(TEXT(ROW($1:$4999),"0000"),2,1),"0;;1")*TEXT(MID(TEXT(ROW($1:$4999),"0000"),3,1),"0;;1")*TEXT(MID(TEXT(ROW($1:$4999),"0000"),4,1),"0;;1"),),-1)



留言