Need help with possible formula
 

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...fo&userid=6998
View this thread: http://www.excelforum.com/showthread...hreadid=541534

Need help with possible formula
 

Hi Michael,

Have a look at Chip's page:
http://www.cpearson.com/excel/duplic...CountingUnique

hth
Rob Brockett
NZ
Always learning & the best way to learn is to experience...


--
broro183
------------------------------------------------------------------------
broro183's Profile: http://www.excelforum.com/member.php...o&userid=30068
View this thread: http://www.excelforum.com/showthread...hreadid=541534

Need help with possible formula
 

On Fri, 12 May 2006 08:00:48 -0500, Michael Wise
wrote:


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

One way:

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

HTH
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________

Need help with possible formula
 

Hi Michael,

Look he

http://www.cpearson.com/excel/duplic...CountingUnique

--
Kind regards,

Niek Otten

"Michael Wise" wrote in message
news:Michael.Wise.27p4am_1147439407.1873@excelforu m-nospam.com...
|
| 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...fo&userid=6998
| View this thread: http://www.excelforum.com/showthread...hreadid=541534
|

Need help with possible formula
 

Hi Michael,

Have a look at Chip's page:
http://www.cpearson.com/excel/duplic...CountingUnique

hth
Rob Brockett
NZ
Always learning & the best way to learn is to experience...


--
broro183
------------------------------------------------------------------------
broro183's Profile: http://www.excelforum.com/member.php...o&userid=30068
View this thread: http://www.excelforum.com/showthread...hreadid=541534