countif but only unique values

[VbaHell]

Hello all

Can I have help please on this formula

What I would like is for the count if statement only to count the unique value cells (Ignore any duplicate values)
There could be blank cells in the column as well which should be ignored

=COUNTIF(H13:H1048576,">""")

Is this possible please

 

[Kamolga]

=sumproduct(1/countif(h13:h1048576,h13:h1048576&""))

 

[VbaHell]

Thanks Kamolga