UNIQUE COUNT IN EXCEL

{=SUMPRODUCT(1/COUNTIF(A8:A18,A8:A18))}


A              



Name Amount
a  £    80.00
b  £    33.00
c  £    56.00
d  £    88.00
a  £    80.00
f  £    60.00
g  £    55.00
a  £    80.00
i  £    90.00
j  £    96.00
a  £    80.00

Comments

Popular posts from this blog

50 Excel VBA Oral Interview Questions