Distinct values within a column
Posted by Andrew Miller on January 09, 2002 1:43 PM
Is there any way to calculate how many distinct values appear in a column. My column is much larger with many more values, but for instance say I have a column that has 3 cells in it. The value in the first cell is DO12, the second is DO12, and the third is DO13. I only have two distinct values (DO12 and DO13) in this column. Is there any way to automatically return a value that tells me the number of distinct values? Thanks.