Darren_workforce
Board Regular
- Joined
- Oct 13, 2022
- Messages
- 136
- Office Version
- 365
- Platform
- Windows
Hello,
I had trouble locating this elsewhere unless I was typing the wrong search info.
I am using a FILTER formula that is retrieving data from my source tab based on phone queues that our reps are skilled to. It works just fine for 10 of our queues. However, queue #11 is simply called 'cst' and we have 3 phone queues that have the acronym cst within it (cst, cst_fees, cst_deposits). Since I am able to filter using the full name, I do not have issues with the cst_fees or cst_deposits columns. However, for the column that is searching for just 'cst', it returns ALL instances from all 3 queues.
Is there a way to search for 'cst' without it also returning positive results from my cst_deposits or cst_fees queues? Below is what the formula looks like for reference. A1 is the cell in which my queue name is listed. I tried with and without wildcard asterisks but I'm clearly missing something.
=FILTER('Agent Report 2023'!C:C,ISNUMBER(SEARCH(A1,'Agent Report 2023'!B:B)),"")
Thank you in advance for your assistance.
I had trouble locating this elsewhere unless I was typing the wrong search info.
I am using a FILTER formula that is retrieving data from my source tab based on phone queues that our reps are skilled to. It works just fine for 10 of our queues. However, queue #11 is simply called 'cst' and we have 3 phone queues that have the acronym cst within it (cst, cst_fees, cst_deposits). Since I am able to filter using the full name, I do not have issues with the cst_fees or cst_deposits columns. However, for the column that is searching for just 'cst', it returns ALL instances from all 3 queues.
Is there a way to search for 'cst' without it also returning positive results from my cst_deposits or cst_fees queues? Below is what the formula looks like for reference. A1 is the cell in which my queue name is listed. I tried with and without wildcard asterisks but I'm clearly missing something.
=FILTER('Agent Report 2023'!C:C,ISNUMBER(SEARCH(A1,'Agent Report 2023'!B:B)),"")
Thank you in advance for your assistance.