Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Genarating count of unique words in a cell or cells
Hi,
Suppose in cell A1 I have a text --- "I had some bread in morning. I had some eggs at night." Is it possible to programmatically get a count of unique words in the above string. Like in column B the unique words are listed one word in each row in the following manner..B1 -- "I" B2 -- "I B2 -- "had B3 -- "some" B4 -- "bread" B5 -- "in" B6 -- "morning" B7 -- "eggs" B8 -- "at" B9 -- "night" Actually I can use excel's text to columns feature ( using space as a delimiter) but automating is a problem. Like I have 500 or so rows of data and out of those rows I want to get count of unique words within those 500 rows ( basically a consolidated unique list..). Now, each row would be having different number of words so, programmatically how would it be implemented. Please guide me if possible. Regards, Hari India |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count the words in a cell | Excel Worksheet Functions | |||
Is it possible to count specific words in a number of cells? | Excel Discussion (Misc queries) | |||
How do I count the number of words in a cell? | Excel Worksheet Functions | |||
count cells with unique numbers | Excel Worksheet Functions | |||
Count the number of words in a cell! | Excel Worksheet Functions |