5列的公式不一致,下面是a列的公司
A12单元格公式:
=IF(B12="","",INDEX(A$1:A$10,QUOTIENT(MOD(ROW()-ROW($A$11)-1,COUNTA(A$2:A$10)*COUNTA(B$2:B$10)*COUNTA(C$2:C$10)*COUNTA(D$2:D$10)*COUNTA(E$2:E$10)),COUNTA(B$2:B$10)*COUNTA(C$2:C$10)*COUNTA(D$2:D$10)*COUNTA(E$2:E$10))+2))
下面是截图,其它公式见附件。