每行1~99都出現數字 行數不固定 (12570)

N2{=IFERROR(SMALL(IF(MMULT(COLUMN(A:I)^0,1-ISERR(FIND(","&COLUMN(A:CU)&",",","&M$1:M$9&",")))=COUNTA(M$1:M$9),COLUMN(A:CU)),ROW(A2)),"")



留言