How many different numbers in an array
 

I'm trying to determine how many different numbers (disregarding duplicates)
are in an array of numbers (a1.a400). Thanks.

How many different numbers in an array
 

Ctrl+Shift+Enter
=SUM(IF(FREQUENCY(A1:A400, A1:A400)0,1))
Rossta wrote:
I'm trying to determine how many different numbers (disregarding duplicates)
are in an array of numbers (a1.a400). Thanks.

How many different numbers in an array
 

Try this:

=COUNT(1/FREQUENCY(A1:A400,A1:A400))

--
Biff
Microsoft Excel MVP


"Rossta" wrote in message
...
I'm trying to determine how many different numbers (disregarding
duplicates)
are in an array of numbers (a1.a400). Thanks.

How many different numbers in an array
 

OR:
Ctrl+shift+enter
=SUM(1/COUNTIF(A1:A400,A1:A400))

"Rossta" wrote:

I'm trying to determine how many different numbers (disregarding duplicates)
are in an array of numbers (a1.a400). Thanks.

How many different numbers in an array
 

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


"Bob Umlas, Excel MVP" wrote in
message ...
OR:
Ctrl+shift+enter
=SUM(1/COUNTIF(A1:A400,A1:A400))

"Rossta" wrote:

I'm trying to determine how many different numbers (disregarding
duplicates)
are in an array of numbers (a1.a400). Thanks.