Home > Microsoft Excel, Microsoft Office > Sort rows on specific word

Sort rows on specific word

Lets say you have a glossary in 2 columns (A and B) and you want to check all the cells that refer you to another headword with the string see x. or βλέπε or even a specific character like a parenthesis. Let’s say you want to check for instances of this string on column B with all the rows that contain the given string.

1. In column C, header row (C1), enter the phrase/string/character to find.
2. In C2 enter =ISNUMBER(SEARCH(C$1; B2)) and then drag C2 all the way down (if that gives you an error try with this: =ISNUMBER(SEARCH(C$1, B2)) ).
3. If you dragged, you will see that column C cells change to TRUE or FALSE.
4. Sort on column C.
5. Go to the bottom where you will most likely find all the cells that contain the phrase/string/character.

If you want to check for a term on column A, use this instead:

=ISNUMBER(SEARCH(C$1; A2)) or =ISNUMBER(SEARCH(C$1, A2))

  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: