Thread: Counting Different Names in A Column... Formula?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Ron Coderre Ron Coderre is offline
external usenet poster
  
Posts: 1
Default Counting Different Names in A Column... Formula?

Try this

For a list of names (with possible multiples) in A1:A10

This formula returns the count of unique items:
B1: =SUMPRODUCT((A1:A10<"")/COUNTIF(A1:A10,A1:A10&""))

Does that help?

Regards,

Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=571093

Reply With QuoteReply With Quote