countdiff() counts 533 while uniquevalue() lists 539 !!!

countdiff() counts 533 while uniquevalue() lists 539 !!!

Post by RWRkeSBTdG » Mon, 31 Aug 2009 07:31:01


Hi

did any one tried.

I was extracting data by uniquevalues function in morefunctions add in set
(539), but countdiff() of morefunctions count only 533 instead of 539
range of my data is only 4061 rows
- no blanks in data set, i used.
any reason / explanation !!

I wish countdiff() worked correctly.

eddy stan
 
 
 

countdiff() counts 533 while uniquevalue() lists 539 !!!

Post by Ron Rosenf » Mon, 31 Aug 2009 10:30:10

On Sat, 29 Aug 2009 15:31:01 -0700, Eddy Stan



How can you tell that countdiff() is incorrect rather than uniquevalues()?
--ron