指定區 任一非0 提出 (14151)

N1:W9{=IFERROR(OFFSET($A$1,MATCH($M2,$A:$A,)-1,SMALL(IF(MMULT(COLUMN(A:H)^0,COUNTIF($M:$M,$A$2:$A$9)*$B$2:$K$9),COLUMN($A:$J)),COLUMN(A2))),"")

A2:K9格式化=COUNTIF($M:$M,$A2)