footprints
New Member
- Joined
- Jul 1, 2008
- Messages
- 3
Hi,
Using VBA, I'm trying to count how many times the following strings appear on the the report:
BTC, WD, ABC, XYZ
The challenge is the cell may contain both 'stand alone' or combination of those characters..so something like this:
- BTC, Wd, abcblablaba, xyz
- btC, wd
- klm, SC, WD
- blbalbalXYZ
- blablabaxyz
- xyz,abc, btc
- XYT, XYZ, BTC
In this example, the total count are:
BTC: 4
WD: 3
ABC: 2
XYZ: 5
So whether it's standalone or combination, mixed upper/lowercase, spaces in between... I just want to get a count of how many times that those specific character appear, i.e:
- blbalbalXYZ -> count as 1 XYZ
- xyz -> count as 1 XYZ
- ...., xyz -> count as 1 XYZ
so doesn't matter how/what/where the combination are, as long as that specific character appears, then it gets counted.
Using VBA, I'm trying to count how many times the following strings appear on the the report:
BTC, WD, ABC, XYZ
The challenge is the cell may contain both 'stand alone' or combination of those characters..so something like this:
- BTC, Wd, abcblablaba, xyz
- btC, wd
- klm, SC, WD
- blbalbalXYZ
- blablabaxyz
- xyz,abc, btc
- XYT, XYZ, BTC
In this example, the total count are:
BTC: 4
WD: 3
ABC: 2
XYZ: 5
So whether it's standalone or combination, mixed upper/lowercase, spaces in between... I just want to get a count of how many times that those specific character appear, i.e:
- blbalbalXYZ -> count as 1 XYZ
- xyz -> count as 1 XYZ
- ...., xyz -> count as 1 XYZ
so doesn't matter how/what/where the combination are, as long as that specific character appears, then it gets counted.