I have a column which has a variable number of comma delimited values in the
range of 11 to 56 in each cell. Is there a method or macro to count the
occurrences of each number in the column and either output the results to a
file or another worksheet?

Example:
23,40,52,31,
42,14,
56,
27,43,19,
etc.

What I am doing now is coping the column to Word, closing the margins to 3
characters, coping that result to an clean worksheet, sorting the new column
ascending and printing the results and counting the occurrences manually.
This is getting tedious as the column grows in length.

Can anyone help me or point me to a solution?

Thanks in advance!

Glynn ..

OT: isn't there a program to sort a comma delimited ASCII numeric file?
Seems like I remember one from the DOS days.