指定欄行範圍 相同數 (14704)

E2{=SUM(N(INDIRECT(H1&H2&":"&H1&H3)=TRANSPOSE(INDIRECT(J1&J2&":"&J1&J3))))

另解{=COUNT(MATCH(OFFSET(B1,H2-1,,H3-H2+1),OFFSET(C1,J2-1,,J3-J2+1),))

B2:C16格式化=MEDIAN(ROW(),OFFSET($H$2,,(G$1=$H$1)*2,2))=ROW()