=SUMPRODUCT((A1:A10<"")/COUNTIF(A1:A10,A1:A10&""))

andifak wrote:

is there any exel fuction to counting how many distinct data like distinct
funtion on sql programming
example

1 ab
2 ab
3 ac
4 ad
the result should be 3 not 4, i had use counta or count fuction butdoesn't
work


--

Dave Peterson