S
smilroy
Hello,
I need to add text based on the occurrence of text in string but
cannot discount the remainder of a string.
I am looking for the occurrence aaaa.bbb.ccc in the following text an
I need them counted but also based on criteria in another field, a
follows:
Column A Column B
aa.bb Yes
aa.bb.cc No
aa.bb.cc.dd Yes
aa.bb.cc.dd.ee Yes
aa.bb.cc.dd.ee.ff Yes
aa.bb.cc.dd.ee.ff.gg No
bc.dd.cc.ee.ff.gg.hhh
bc.ba.cc.ee.ff
I need to count all of the occurrences of aa.bb but also include thos
which have text beyond aa.bb in the account. The aa.bb denotes an are
of the company and get's more specific the longer the line of text is.
I am trying to add up the numbers of aa.bb where column b=yes bu
Excell does not seem to include the cells which have text beyond th
aa.bb (i.e aa.bb.cc.dd.ee, etc.)
Any help would be greatly appreciated.
Thanks,
Sco
I need to add text based on the occurrence of text in string but
cannot discount the remainder of a string.
I am looking for the occurrence aaaa.bbb.ccc in the following text an
I need them counted but also based on criteria in another field, a
follows:
Column A Column B
aa.bb Yes
aa.bb.cc No
aa.bb.cc.dd Yes
aa.bb.cc.dd.ee Yes
aa.bb.cc.dd.ee.ff Yes
aa.bb.cc.dd.ee.ff.gg No
bc.dd.cc.ee.ff.gg.hhh
bc.ba.cc.ee.ff
I need to count all of the occurrences of aa.bb but also include thos
which have text beyond aa.bb in the account. The aa.bb denotes an are
of the company and get's more specific the longer the line of text is.
I am trying to add up the numbers of aa.bb where column b=yes bu
Excell does not seem to include the cells which have text beyond th
aa.bb (i.e aa.bb.cc.dd.ee, etc.)
Any help would be greatly appreciated.
Thanks,
Sco