Would you care to tell us why you don't have that option?
--
David Biddulph

"porter444" wrote in message
...
I don't have that option.

"Pranav Vaidya" wrote:

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!!

"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