tonywatsonhelp
Well-known Member
- Joined
- Feb 24, 2014
- Messages
- 3,201
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
Hi Everyone,
I have a sheet call "Extended" which has lots of sales in it
column O is the region
however its not showing as i need
for eg it might say "Hello CD" or "Howard CD" or "TimeCD" or something complete different! but always ends with "CD" (if it doesn't i dont want to count them)
so what i need is this,
A macro that can Countif the last two Letters in each cell are "CD"
So for example
I have a sheet call "Extended" which has lots of sales in it
column O is the region
however its not showing as i need
for eg it might say "Hello CD" or "Howard CD" or "TimeCD" or something complete different! but always ends with "CD" (if it doesn't i dont want to count them)
so what i need is this,
A macro that can Countif the last two Letters in each cell are "CD"
So for example
Column O | |||||
Hell CD | count | ||||
PlaceHQ | |||||
BIG House | |||||
TonyCD | count | ||||
hands of CD | count | ||||
Wow CD | count | ||||
Nothing | |||||
Me | |||||
Help | So the count is 4 |