Thursday 21 January 2010

How to sort rows on the basis of whether they contain a specific word/string

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.