Count Number of Different Cells
 

B6:b45 includes a list of ID numbers. Some of the ID numbers will be
repeats. I need a formula that will count the number of different
IDs.

Thanks.


--
ForSale
------------------------------------------------------------------------
ForSale's Profile: http://www.excelforum.com/member.php...o&userid=11896
View this thread: http://www.excelforum.com/showthread...hreadid=550077

Count Number of Different Cells
 

Make sure there is no empy cells in that range.

=SUM(1/COUNTIF(B6:B35,B6:B35))

after you put that in the formula box, press control, shift and enter

Hope that helps


--
Bearacade


------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=550077

Count Number of Different Cells
 

Try...

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

Hope this helps!

In article ,
ForSale wrote:

B6:b45 includes a list of ID numbers. Some of the ID numbers will be
repeats. I need a formula that will count the number of different
IDs.

Thanks.

Count Number of Different Cells
 

Thanks to both.


--
ForSale
------------------------------------------------------------------------
ForSale's Profile: http://www.excelforum.com/member.php...o&userid=11896
View this thread: http://www.excelforum.com/showthread...hreadid=550077