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