View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
mmatz mmatz is offline
external usenet poster
 
Posts: 4
Default count different instances in a list

I have a list that has aaa, bbb, cccc, aaa, bbb and want to count the
different instances. So in this example it would be 3 because bbb is
repeated. Is there a formula that does this?