三區均重複值+排序 (12138)

B18:N18{=IFERROR(SMALL(IF((COUNTIF($B7:$K14,$B7:$K14)=3)*(COUNTIF($A18:A18,$B7:$K14)=0),$B7:$K14),1),"")

另解=TEXT(SMALL(--TEXT(SUMIF($B13:$K14,SUMIF($B7:$K8,$B10:$K11)),"0;;99"),COLUMN(A1)),"[<99]0;")



留言