Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Frequency Function?
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Function '=Frequency' Help! | Excel Worksheet Functions | |||
Frequency Function | Excel Worksheet Functions | |||
Frequency Function | Excel Worksheet Functions | |||
Frequency function | Excel Discussion (Misc queries) | |||
Is there a 'frequency' function?? | Excel Programming |