彙整二區資料成一欄 (12795)

H3 下拉{=IFERROR(RIGHT(SMALL(IF(IF({1,0},B$3:B$99,E$3:E$99)>0,ROW($3:$99)*10^11+{1,2}*10^9+IF({1,0},TEXT(B$3:B$99,"MMDD!1")&C$3:C$99,TEXT(E$3:E$99,"MMDD!2")&F$3:F$99)),ROW(A1)),9),"")