区间内顯示 兩兩一区间 (10506)

I3:Q3=IFERROR(LOOKUP(1,0/(N(OFFSET($A2,,{0,2,4}))<=I1)/(N(OFFSET($B2,,{0,2,4}))>=I1),T(OFFSET($A1,,{0,2,4}))),"")

另解=IFERROR(LOOKUP(1,0/(I1>=$A2:$E2)/(I1<=$B2:$F2)/(MOD(COLUMN($A:$F),2)=1),$A1:$F1),"")

另解=IFERROR(LOOKUP(1,0/FREQUENCY(I1,N(OFFSET($A2,,{0,1;2,3;4,5}))+{-0.1,0.1})/(MOD(ROW($1:$7),2)=0),$A1:$F1),"")