| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Countdiff with more criteria | Excel Worksheet Functions | |||
| average daily counts to weekly counts | Excel Discussion (Misc queries) | |||
| counts | Excel Discussion (Misc queries) | |||
| Counts | Excel Discussion (Misc queries) | |||
| Counts more than one | Excel Programming | |||
Hybrid Mode
