出現次數區間 指定顯數字 (10875)


N2=LOOKUP(COUNTIF(B:J,L2),{0,2,4,5,8,10,12,13},{0,1,0,2,0,3,0,4})


S2=IFERROR(LOOKUP(1,0/(COUNTIF(B:J,L2)>=P$2:P$5)/(COUNTIF(B:J,L2)<=Q$2:Q$5),R$2:R$5),)


留言