三區間出現次數 可自動計算 (14390)

F3:H5{=INDEX(FREQUENCY(IF($B$2:$B$16=$E3,$C$2:$C$16),MID(SUBSTITUTE($G$2,"-",REPT(" ",9)),{1,9},9)-{1,0}),COLUMN(A1))



留言