求因數且是質數 (13553)

B2{=IFERROR(SMALL(IF(MOD(A$1,ROW(INDIRECT("1:"&A$1)))=0,ROW(INDIRECT("1:"&A$1))),ROW(A1)),"")

C2{=IFERROR(SMALL(IF((MMULT(N(MOD(ROW(INDIRECT("1:"&A$1)),TRANSPOSE(ROW(INDIRECT("1:"&A$1))))=0),ROW(INDIRECT("1:"&A$1))^0)=2)*(MOD(A$1,ROW(INDIRECT("1:"&A$1)))=0),ROW(INDIRECT("1:"&A$1))),ROW(A1)),"")

利用B欄 C2{=IFERROR(SMALL(IF((MMULT(N(MOD((0&B$2:B$99)*1,TRANSPOSE(ROW(INDIRECT("1:"&A$1))))=0),ROW(INDIRECT("1:"&A$1))^0)=2)*(B$2:B$99<>""),B$2:B$99),ROW(A1)),"")