View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default countdiff() counts 533 while uniquevalue() lists 539 !!!

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

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


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