software

Is it possible for me to have excel sum all the one letter codes into
individual cells and let me know the count?

Ie. (AAABBCDDDD) A=3, B=2, C=1, D=4
and have those sums placed in an individual cell for each?

Thanks for the help.--
Pookie76
------------------------------------------------------------------------
Pookie76's Profile: www.excelforum.com/member.php...oamp;userid=12815
View this thread: www.excelforum.com/showthread...hreadid=527651
Try this:

For a value in A2
And B1: A
And C1: B

B2: =LEN(A2)-LEN(SUBSTITUTE(UPPER(A2),B$1,quot;quot;))
C2: =LEN(A2)-LEN(SUBSTITUTE(UPPER(A2),C$1,quot;quot;))

Those formulas return the counts of quot;Aquot; and quot;Bquot; in cell A2,
respectively.

Is that something you can work with?

Ron--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: www.excelforum.com/member.php...oamp;userid=21419
View this thread: www.excelforum.com/showthread...hreadid=527651try
=LEN(A1)-LEN(SUBSTITUTE(UPPER(A1),quot;Aquot;,quot;quot;))
or if b1 contains A
=LEN(A1)-LEN(SUBSTITUTE(UPPER(A1),b1,quot;quot;))

--
Don Guillett
SalesAid Software

quot;Pookie76quot; gt; wrote in
message ...
gt;
gt; Is it possible for me to have excel sum all the one letter codes into
gt; individual cells and let me know the count?
gt;
gt; Ie. (AAABBCDDDD) A=3, B=2, C=1, D=4
gt; and have those sums placed in an individual cell for each?
gt;
gt; Thanks for the help.
gt;
gt;
gt; --
gt; Pookie76
gt; ------------------------------------------------------------------------
gt; Pookie76's Profile:
gt; www.excelforum.com/member.php...oamp;userid=12815
gt; View this thread: www.excelforum.com/showthread...hreadid=527651
gt;
Assuming that A2 contains the text string, let C2:C5 contain A, B, C,
and D, then enter the following formula in D2 and copy down:

=SUMPRODUCT(--(MID($A$2,ROW(INDEX($A:$A,1):INDEX($A:$A,LEN($A$2) )),1)=C2)
)

Hope this helps!

In article gt;,
Pookie76 gt;
wrote:

gt; Is it possible for me to have excel sum all the one letter codes into
gt; individual cells and let me know the count?
gt;
gt; Ie. (AAABBCDDDD) A=3, B=2, C=1, D=4
gt; and have those sums placed in an individual cell for each?
gt;
gt; Thanks for the help.


Thanks again for all the help. It works perfectly.--
Pookie76
------------------------------------------------------------------------
Pookie76's Profile: www.excelforum.com/member.php...oamp;userid=12815
View this thread: www.excelforum.com/showthread...hreadid=527651