View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Umby Umby is offline
external usenet poster
 
Posts: 3
Default Most popular word

Hi all,
I need a function to get the most frequent word in a cell. The length of the
output must be at least 3.
e.g. if a cell contents was "Vick rushed for 145 yards. Michael Vick handled
things in regulation. established in 1881 ; Yards Gear for the Holidays car
yards in crisis" , the output should be "yards".

Any idea?
Thank you.

Umby