出现次数第1~2多與少 (9004)

AE6:AX11{=IFERROR(SMALL(IF($E6:$AC6=ABS(LARGE(IF(MATCH($E6:$AC6,$E6:$AC6,)=$E$1:$AC$1,$E6:$AC6*IF(COLUMN(A1)>10,-1,1)),MOD(INT(COLUMN(E1)/5)-1,2)+1)),$E$1:$AC$1),MOD(COLUMN(A1)-1,5)+1),"")