Thread: count number of text in a column
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Daniel_ITSM[_2_] Daniel_ITSM[_2_] is offline
external usenet poster
  
Posts: 14
Default count number of text in a column
Look at this then and tell me how I could get the report desired without
explictly naming each cell reference or actual name? My column 5800 cells
with multiple and single entries.

Unique Names Names used
Daniel Daniel, Celia
Celia Daniel
Sherlock Batman,Sherlock
Batman Daniel
Celia

Report then would be:
Daniel 3
Celia 2
Batman 1
Sherlock 1

Reply With QuoteReply With Quote