在A1:A6分别为1到12的数,请找出A1:A6中有重复的数,(答案在A7里,)如:A1=3,A2=2,A3=3,A4=8,6,A5=11,7,11,A6=7,A7=答案：7,3请给条公式?A5中有2个重复的数11,11但不在其他行中就不选.A4单元格里有两个数,

Question

在A1:A6分别为1到12的数,请找出A1:A6中有重复的数,(答案在A7里,)
如:
A1= 3,
A2= 2,
A3= 3,
A4= 8,6,
A5= 11,7,11,
A6= 7,
A7=答案：7 ,3
请给条公式?
A5中有2个重复的数11,11但不在其他行中就不选.A4单元格里有两个数,但用逗号隔开.

Answer 1

=TEXT(SUBSTITUTE(SUM((MMULT(1*ISNUMBER(FIND(","&ROW($1:$9)&",",","&TRANSPOSE(A1:A6))),ROW($1:$6)^0)>1)*ROW($1:$9)*10^(9-ROW($1:$9))),0,),REPT("0!,",SUM(1*(MMULT(1*ISNUMBER(FIND(","&ROW($1:$9)&",",","&TRANSPOSE(A1:A6))),ROW($1:$6)^0)>1))-1)&"0")&IF(SUM(1*ISNUMBER(FIND(",10,",","&A1:A6)))>1,",10",)&IF(SUM(1*ISNUMBER(FIND(",11,",","&A1:A6)))>1,",11",)&IF(SUM(1*ISNUMBER(FIND(",12,",","&A1:A6)))>1,",12",)
注：公式以CTRL+SHIFT+回车结束.