重复值 取出 (11073)

G7:T7 {=IFERROR(INDIRECT(TEXT(RIGHT(LARGE(IF((COUNTIF($G10:$Q12,$G10:$Q12)>1)*($G10:$Q12<>""),N(+$G10:$Q12)/1%%+{10;11;12}/1%+COLUMN($G:$Q)),COLUMN(A1)),4),"!R0C00"),),"")