加減後 取不重複 (11036)

E2{=IFERROR(SMALL(IF(MOD(C$3:C$22,2)*(COUNTIF(E$1:E2,C$3:C$22+{-2,-1,1,2})=0),C$3:C$22+{-2,-1,1,2}),1),"")

另解{=TEXT(MOD(MIN(IF(MOD(C$3:C$22,2),B$3:B$22/1%+IF(COUNTIF(E$1:E2,C$3:C$22+{-2,-1,1,2}),9900,C$3:C$22+{-2,-1,1,2}))),100),"0;;;")