區間值 同字母打勾 (14827)

C4:N11=IFERROR(REPT("V",MEDIAN(SUBSTITUTE($B4,C$2,)*1,TEXT({1,-1}%,SUBSTITUTE(C$3,"-",";"))*1)-SUBSTITUTE($B4,C$2,)=0),"")