Limit in Count Distinct Formula
I had this unpleasent experience using the following formula =COUNT(DISTINCT(data1:data1000))
It happens that the formula works only for the first 400 lines =COUNT(DISTINCT(data1:data400)) then the result will always be 1.
Is it a bug or am I doing something wrong?
Answers

What kind of data is in that column? Also have you tried doing =Count(Distinct(data:data)) Which should grab the entire column?
Also, have you tried seeing what =Distinct(data1:data1000) outputs?

"What kind of data is in that column? SANITARY CODES 12 digits Letters and numbers like"
ADKELSHY598W
"Also have you tried doing =Count(Distinct(data:data)) Which should grab the entire column?"
Yes, same result.
Also, have you tried seeing what =Distinct(data1:data1000) outputs?
Yes all 1 if you select more than exactly 396 column if below the number is right

Did you make that a column formula? It looks like you're running that formula down the entire column. This formula should exist in a single cell... There is a strange mention of this issue on the notes section of the explanation of this formula. Do you have some values that all numbers in this list?
I would also try selecting a smaller portion of the data and see if still shows 1. Something in that range is causing it to fail.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 10.7K Get Help
 63 Global Discussions
 69 Industry Talk
 385 Announcements
 3.5K Ideas & Feature Requests
 55 Brandfolder
 125 Just for fun
 50 Community Job Board
 464 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!