Count Distinct is Clearly Incorrect.

A.J.

I have a sheet with approximately 18,000 rows. One column is called "ID". I have a support column where I am trying to understand how many unique entries are in "ID" and I am using this formula:

=COUNT(DISTINCT(ID:ID))

It's returning a value of 1 (which is clearly not correct). The column is a text column. There are no special characters in the column at all.

Has anybody seen this? What am I missing?

Jason Tarpinian

Check to make sure that you don't have any #ERROR in the range you're calculating. I'm able to replicate your issue with it returning 1 with an #ERROR int eh range, but once I remove it, it counts up as it should.