Just discovered that the COUNTA and the COUNTUNIQUE functions are not case sensitive if you apply them to text.
This is quite amateurish by Google!
This "feature" is undocumented and there is no parameter available to control it. Quite disappointing! It is a huge problem e.g. when you are looking for duplicates (e.g. AA is perhaps not the same as Aa).
No comments:
Post a Comment