Thread: Genarating count of unique words in a cell or cells
View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.programming
Peter T Peter T is offline
external usenet poster
  
Posts: 5,600
Default Genarating count of unique words in a cell or cells
You could use a worksheet formula:

=SUMPRODUCT((ref<"")*(LEN(TRIM(ref))+1-LEN(SUBSTITUTE(ref," ",""))))

Regards
Peter T

Ignore - I totally misread "unique"
Peter T


Reply With QuoteReply With Quote