Counting only unique values.
I hope someone can help me here, I'm sure there is an easy way to do this. I am looking to set up a calculation to only count unique values...
For example if I have 5 records with the following ID's:
ID1, ID2, ID2, ID3, ID4, ...the count will return 4 only counting each unique value.
And if I have 10 records say with the ID's:
ID1, ID2, ID2, ID3, ID4, ID5, ID6, ID7, ID8, ID8 ...the count will return 8 counting only each unique value
I hope someone can help me this this,