LittlegmoonBH
New Member
- Joined
- May 2, 2019
- Messages
- 15
Hello!
I'm building a dashboard and using
“COUNTIF” to simply count the number of times a complaint isowned by a particular person or process… The issue I’m having is new ownershave been added to the data and the begin with < or > for example
<over font="" old<="" 5years=""></over>
>Less than 5 years Old
These have been used to implement a temporary process andthere’s over 20 of them. My COUNTIF is looking at all of the options in exactlythe same way and giving me the same volume.
How do I tell my formula to ignore the < or > prefix?
I'm building a dashboard and using
“COUNTIF” to simply count the number of times a complaint isowned by a particular person or process… The issue I’m having is new ownershave been added to the data and the begin with < or > for example
<over font="" old<="" 5years=""></over>
>Less than 5 years Old
These have been used to implement a temporary process andthere’s over 20 of them. My COUNTIF is looking at all of the options in exactlythe same way and giving me the same volume.
How do I tell my formula to ignore the < or > prefix?