modytrane
Valued Forum Contributor

Hello modytrane,

I was wondering if you had seen the solution I posted for you yesterday about adding the CheckBoxes?
Click to view post

Thanks,
Leith Ross

i saw where you replied to my post, but i dont see your formula in the attachment

Lets see what the OP wants instead of hijacking his thread for a chat

Modytrane,

I saw a post you help someone on and it is almost exactly what I'm trying to do and I was wondering if I could get your help.

The post is located at the following link:

http://www.excelforum.com/excel-gene...bulk-list.html

In the example at this link it creates a unique list from a range of cells, but I want is to create a unique list form words in a string. For example:

"word1,word2,word3 word1,word3 word2"

What I would like returned is the following:

word1 = 2
word2 = 2
word3 = 2

Can you help?

Thanks,

Glenn