Need help with possible formula

M

Michael Wise

I need to find the count of a list of numbers listed in a
column(specific). But where the number exists more than once I need it
to be counted only once. In the example below this formula should
return 4 as the answer. Thanks in advance.

Example:

Column B
23789
24567
23789
14578
09075
23789
 
R

Richard Buttrey

I need to find the count of a list of numbers listed in a
column(specific). But where the number exists more than once I need it
to be counted only once. In the example below this formula should
return 4 as the answer. Thanks in advance.

Example:

Column B
23789
24567
23789
14578
09075
23789
Click to expand...

One way:

=SUMPRODUCT((B1:B6<>"")/COUNTIF(B1:B6,B1:B6&""))

HTH
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________
 
N

Niek Otten

Hi Michael,

Look here:

http://www.cpearson.com/excel/duplicat.htm#CountingUnique

--
Kind regards,

Niek Otten

|
| I need to find the count of a list of numbers listed in a
| column(specific). But where the number exists more than once I need it
| to be counted only once. In the example below this formula should
| return 4 as the answer. Thanks in advance.
|
| Example:
|
| Column B
| 23789
| 24567
| 23789
| 14578
| 09075
| 23789
|
|
| --
| Michael Wise
| ------------------------------------------------------------------------
| Michael Wise's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=6998
| View this thread: http://www.excelforum.com/showthread.php?threadid=541534
|
 
Top