Search by specific text that appears in multiple instances

[Darren_workforce]

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.

 

[Fluff]

How about

=FILTER('Agent Report 2023'!C:C,A1='Agent Report 2023'!B:B,"")

 

[Darren_workforce]

=FILTER('Agent Report 2023'!C:C,A1='Agent Report 2023'!B:B,"")

It's not displaying anything. It doesn't say SPILL or anything. It's just blank

 

[Fluff]

In that case can you please post some sample data.

 

[Darren_workforce]

In that case can you please post some sample data.

It won't let me upload as a mini-sheet and IT has this locked down

Tab Agent Report

Tab Sheet2

formula in each cell in Row 2 is =FILTER('Agent Report 2023'!C:C,ISNUMBER(SEARCH(A1,'Agent Report 2023'!B:B)),"") with the A1 adjusted based on the column

 

[Fluff]

Ok, How about

=FILTER('Agent Report 2023'!C:C,ISNUMBER(SEARCH(A1&",",'Agent Report 2023'!B:B&",")),"")

 

[Darren_workforce]

Disregard the hyperlinks. That's just something that happens.

FILTER('Agent Report 2023'!C:C,ISNUMBER(SEARCH(A1&",",'Agent Report 2023'!B:B&",")),"")

OK that did the trick! Thank you again Fluff for your FILTER knowledge.

 

[Fluff]

You're welcome & thanks for the feedback.