Counting without double counting

[Guest]

I have a list of numbers. Some numbers are the same. I want to count how many numbers are in the list. But I don't want to count the same number more than once.

For instance: 1, 67, 4, 32, 4, 3
Should count: 5
The four only gets counted once.

Any help would be greatly appreciated.
Thanks

 

[Aladin Akyurek]

On 2002-03-15 06:56, Anonymous wrote:
I have a list of numbers. Some numbers are the same. I want to count how many numbers are in the list. But I don't want to count the same number more than once.

For instance: 1, 67, 4, 32, 4, 3
Should count: 5
The four only gets counted once.

Any help would be greatly appreciated.
Thanks

=IF(LEN(A1:A10),SUMPRODUCT(1/COUNTIF(A1:A10,A1:A10)))

where A1:A10 houses the target numbers.

 

[Dave Patton]

1. If you want to specify the specific range
for the data (revise to fit your info)

=SUMPRODUCT(1/COUNTIF(A1:A6,A1:A6))

2. If you want to specify a range
that may include blank cells, use
Array formulas such as the following:

a) =SUM(IF(LEN(rData),1/COUNTIF(rData,rData)))

b) =SUM(IF(LEN(A1:A100),1/COUNTIF(A1:A100,A1:A100)))

Enter the Array formulas with Ctrl-Shift-Enter (CSE)

 

[Mark W.]

On 2002-03-15 06:56, Anonymous wrote:
I have a list of numbers. Some numbers are the same. I want to count how many numbers are in the list. But I don't want to count the same number more than once.

For instance: 1, 67, 4, 32, 4, 3
Should count: 5
The four only gets counted once.

Any help would be greatly appreciated.
Thanks

With your values in A1:A6 use...

=COUNT(IF(FREQUENCY(A1:A6,A1:A6),1))