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
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