Thread
:
compare text in cells
View Single Post
#
3
Posted to microsoft.public.excel.programming
[email protected]
external usenet poster
Posts: 4
compare text in cells
On Sunday, 1 March 2015 14:23:00 UTC+1, Claus Busch wrote:
Hi,
Am Sun, 1 Mar 2015 04:31:51 -0800 (PST) schrieb
:
XY A B C A B B A C 3
XX B C A B C A C B 2
I need to count "A" and sumarize it at end of row i.e. 3
if your string is in B1 then:
=LEN(B1)-LEN(SUBSTITUTE(B1,"A",))
If "A" can occur in more columns, e.g . A1:C1 then:
SUM(LEN(A1:C1))-SUM(LEN(SUBSTITUTE(A1:C1,"A",)))
and insert this formula with CTRL+Shift+Enter
Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
Thank you very much for help.
Solution was with COUNTIF ( maybe I did not explain correctly).
Rgds.
Reply With Quote
[email protected]
View Public Profile
Find all posts by
[email protected]