Sorting rows on whether they contain a specific string

Lets say I have a 2 column sheet (A and B). And I want to sort on column B with all the rows that contain a given string, i.e. /g or Δείτε.

Something like doing a find all but then being able to select/copy/cut etc those rows.

How can this be done?

Use col C. In the header row (C1?), enter the phrase to find.

In C2 and down, write a SEARCH or FIND formula to look for C1 in the adjacent B cell. Sort by col C.

Thanks, what would the search formula syntax be like?

In C2 and down, =ISNUMBER(SEARCH(C$1, B2))

Cool, thanks! Works like magic. Is there a way to add an "or" argument? Say, if the word is x or y then it should be TRUE.

=or(isnumber(...), isnumber(...), ...)

Tried these:

Please Login or Register  to view this content.

but did not work. I added the second word in D1 cell.

This works for one word:

=ISNUMBER(SEARCH(C$1;B2))

OR is a function

All functions in Excel are followed by an open paren, their arguments, and a closing paren.

Open and close parens must balance (which follows from the above)

Thanks. I thought I had closed them all in the second instance, kindly clarify as I am not sure what needs to change.

=ORISNUMBER(SEARCH(C$1;B2)), ISNUMBER(SEARCH(D$1;B2))

Should be

=OR(ISNUMBER(SEARCH(C$1;B2));ISNUMBER(SEARCH(D$1;B2)))

Many thanks, much indebted to you for your kind help.

Please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save