统计去除重复值个数以及公式动态引用
2019-02-13 本文已影响0人
护国寺小学生
=SUMPRODUCT(1/COUNTIF(INDIRECT("A1:A"&(1+COUNTA(A1:A24)-1)),INDIRECT("A1:A"&(1+COUNTA(A1:A24)-1))))
=SUMPRODUCT(1/COUNTIF(INDIRECT("A1:A"&(1+COUNTA(A1:A24)-1)),INDIRECT("A1:A"&(1+COUNTA(A1:A24)-1))))
