I think if you use Data--Text to column option and separate on 'comma (,)',
your current data will be split across the columns and the you should be
easily able to do this.

Hope this helps!!
--
Pranav Vaidya
VBA Developer
PN, MH-India
If you think my answer is useful, please rate this post as an ANSWER!!


"porter444" wrote:

Gurus,

Hope you can help me out once again. You guys/gals ROCK!

I have a worksheet that contains survey results and in one column there are
the results of a ranking exercise. The survey respondant enters a list of
numbers that correspond to the 15 most critical items from a list of 50
items. Each item is designated by a number between 1 - 50.

The entry looks like 1,4,6,18,19,23,44,50...

On another worksheet I need to summarize how many times each of the 50 items
makes it into a top 15 response.

In other words I need to be able to count how many times 1 appears in column
D (not 10,11,12,21,31,41...ect.).

My struggle here is coming up with a way to count if the range contains a
specific value, and then how to exclude non-matches like 10,11,12... etc.

Any help you can provide would be AWESOME.

Thanks,

Scott