Unique IF Contains Specific Characters

[RBusiness]

Hi all,

I'm trying to fill in a sheet with only unique items, but within those unique items, those that include /pl/ with the text strings.

Example
Using =unique(A:A) I can get all the unique values in a column but it (they) contain lots of items I don't need.
I want to isolate to only the values that include /pl/ in them.

Original List
/pl/1234
/pl/1234
/pl/2292
/other/9191

Output from Unique Formula Would be
/pl/1234
/pl/2292

Thank you in advance!
RB

 

[Fluff]

How about

=UNIQUE(FILTER(A2:A1000,ISNUMBER(SEARCH("pl",A2:A1000))))

 

[RBusiness]

Fluff - TY This works!
BTW - Fluff was invented in my area!

 

[Fluff]

You're welcome & thanks for the feedback.