R
Rossta
I'm trying to determine how many different numbers (disregarding duplicates)
are in an array of numbers (a1.a400). Thanks.
are in an array of numbers (a1.a400). Thanks.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
JW
Ctrl+Shift+Enter
=SUM(IF(FREQUENCY(A1:A400, A1:A400)>0,1))
=SUM(IF(FREQUENCY(A1:A400, A1:A400)>0,1))
T
T. Valko
Try this:
=COUNT(1/FREQUENCY(A1:A400,A1:A400))
=COUNT(1/FREQUENCY(A1:A400,A1:A400))
B
Bob Umlas, Excel MVP
OR:
Ctrl+shift+enter
=SUM(1/COUNTIF(A1:A400,A1:A400))
Ctrl+shift+enter
=SUM(1/COUNTIF(A1:A400,A1:A400))
P
Peo Sjoblom
It will fail if there are blank cells in the array, you could amend it like
=SUM(IF(A1:A400<>"",1/COUNTIF(A1:A400,A1:A400)))
but then it is less efficient that the other 2 formulas in this thread
--
Regards,
Peo Sjoblom
=SUM(IF(A1:A400<>"",1/COUNTIF(A1:A400,A1:A400)))
but then it is less efficient that the other 2 formulas in this thread
--
Regards,
Peo Sjoblom