ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   countdiff() counts 533 while uniquevalue() lists 539 !!! (https://www.excelbanter.com/excel-programming/433012-countdiff-counts-533-while-uniquevalue-lists-539-a.html)

Eddy Stan

countdiff() counts 533 while uniquevalue() lists 539 !!!
 
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



Ron Rosenfeld

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


All times are GMT +1. The time now is 11:08 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com