Hi everyone,

I use the following function to count # of unique values in a range:

SUM(N(FREQUENCY(A1:A50,A1:A50)0))

In one file, it works well. In another, I don't get right answer!?
Although I don't know what "N" stands for, I wonder what am I missing
here?

I got this function from www.cpearson.com/excel/duplicate.htm which is
now off-line!

Any help why I am getting wrong answer for the 2nd file?

Regards,
Mike

Try: http://www.cpearson.com/excel/duplicat.htm

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Michael" wrote in message
om...
Hi everyone,

I use the following function to count # of unique values in a range:

SUM(N(FREQUENCY(A1:A50,A1:A50)0))

In one file, it works well. In another, I don't get right answer!?
Although I don't know what "N" stands for, I wonder what am I missing
here?

I got this function from www.cpearson.com/excel/duplicate.htm which is
now off-line!

Any help why I am getting wrong answer for the 2nd file?

Regards,
Mike

note re N() function

it converts to number. often useless as excel does it automatically,
but when using array formulas that produce booleans it's used to force the
boolean to 0/1 so the can be summed/counted and frequented :)


keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"Rob van Gelder" wrote:

Try: http://www.cpearson.com/excel/duplicat.htm

Do you have an answer to my question please? Why am I getting wrong
counts in one file while okay in another?

Regards,
Mike


*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!

range probably contains text not numbers.
frequency works with numbers only

cell alignment to general =
if a 'number' remains left aligned you've got your culprit


keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


Michael Sultan wrote:


Do you have an answer to my question please? Why am I getting wrong
counts in one file while okay in another?

Regards,
Mike


*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!

keepITcool wrote in message . ..
range probably contains text not numbers.
frequency works with numbers only

cell alignment to general =
if a 'number' remains left aligned you've got your culprit


keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


Michael Sultan wrote:


Do you have an answer to my question please? Why am I getting wrong
counts in one file while okay in another?

Regards,
Mike


*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!


Hi,

I am positive that my range is just numbers, tried also what you said
about alignment but none worked!?

Don't know why the above function works fine in one file but not in
the other one!?

The function again is: SUM(N(FREQUENCY(A1:A10,A1:A10)0))

Mike