1

In Google Sheets, I am using the formula to create a unique list of words:

=unique(transpose(split(ArrayFormula(concatenate(B2:E"+")),"+")))

But I want to filter out certain strings.

My unique list looks like so:

On the road
Eggs
Bacon
Bread
Hashbrowns
Spreads
Baked Beans
Coffee
Avocado
Pub Roast
Sandwhich meet
Lettuce
Tomato
mustard
mayo
Tom to suss
James to suss
Crisps
Cheese
Crackers
Muslie Bars

I want to filter out strings like Tom to suss, James to suss, On the road, etc.

1
  • This question just has been bumped up by Community User. It already has an answer but it hasn't any comment from you and it's not accepted yet. What do you think of the current answer? Was it helpful?
    – Rubén
    May 14, 2019 at 16:44

1 Answer 1

0

=ARRAYFORMULA(QUERY(UNIQUE(REGEXREPLACE(A1:A, 
 "Tom to suss|James to suss|On the road", "")), 
 "where Col1 is not null"))

0


=ARRAYFORMULA(TRANSPOSE(QUERY(UNIQUE(REGEXREPLACE(A1:A, 
 "Tom to suss|James to suss|On the road", "")), 
 "where Col1 is not null")))

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.