取数字 含 0 (9905)


E2{=IFERROR(INDIRECT(TEXT(SMALL(IF(ISNUMBER(-A$1:C$13)*(A$1:C$13<>""),ROW($1:$13)/1%+{1,2,3}),ROW(A1)),"!R0C00"),),"")


F2{=IFERROR(RIGHT(SMALL(IF(ISNUMBER(-A$1:C$13)*(A$1:C$13<>""),ROW($1:$13)/1%%+{1,2,3}/1%+A$1:C$13),ROW(A1)),2)*1,"")


 


留言