EXCEL经过筛选后 实现自动排列和计算

B1=COUNTIF(A1:A4,A1)B2=COUNTIF(A1:A4,A2)B3=COUNTIF(A1:A4,A3)....C1==B1/COUNT(A1:A4)C2==B2/COUNT(A1:A4)C3==B3/COUNT(A1:A4).....