E2{=IF(ROW(A1)>PRODUCT(MMULT(COLUMN(A:O)^0,N(A$2:C$16>0))),"",SMALL(IF(A$2:A$16>0,A$2:A$16),MOD(ROW(A1)-1,COUNT(A:A))+1))
E2{=IF(ROW(A1)>PRODUCT(MMULT(COLUMN(A:O)^0,N(A$2:C$16>0))),"",SMALL(IF(A$2:A$16>0,A$2:A$16),MOD(ROW(A1)-1,COUNT(A:A))+1))
G2=IF(E2="","",OFFSET(C$1,INT((ROW(A1)-1)/COUNT(A:A)/COUNT(B:B))+1,))
留言
張貼留言