ince you posted your question in an Access database forum I read it as
referring to an Access problem. If you're using Excel, you should ask in
an Excel forum. But first, try using a formula like this in a cell to
the right of one of your "1,2,1,A,C" values - which I'll assume is in
=CountOccurencesInDelimString($A2, "1", ",")
Then fill down the column with the same formula (so the references
adjust to $A3, $A4...).
Next use a =SUM() formula at the foot of this column: that should give
you the count of "1"s.
Repeat in adjacent columns for the other values you want to count.
On Sat, 2 Oct 2004 22:37:01 -0700, "WIM4246"
< XXXX@XXXXX.COM > wrote:
Please respond in the newgroup and not by email.