| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I sum the lowest n numbers in an array with n variable? | Excel Discussion (Misc queries) | |||
| Find numbers in an array that sum to a certain number | Excel Worksheet Functions | |||
| Transpose and order array numbers | Excel Worksheet Functions | |||
| average of kth largest numbers in an array of n numbers | Excel Worksheet Functions | |||
| subtract all numbers in an array | Excel Worksheet Functions | |||
Linear Mode
