Sorting Rows with the Same Word

[nick_floss]

Is there any way to group rows with same words in a certain column?

I have a document with 3000 rows, and I'd like the rows to be sorted by the same word in a column. So, for example, the cells in a column may look like this:

A
1 Red Apple Green
2 Orange Pear Blue
3 Blue Green Orange

I would like the first and second rows to be the ones with "Green" in the column A. Is there a way I can sort that?

 

[venkat1926]

I B1 type this formula

=IF(ISERROR(SEARCH("green",A1)),2,1)

copy B1 down.till the data is available(not more)
now sort the data including columns A and B according to column B ascending.


I you want to do the same thing for green, orange, blue etc the formula will be complicated, better write a macro.

sample sheet wil be

<table x:str="" style="border-collapse: collapse; width: 243pt;" width="324" border="0" cellpadding="0" cellspacing="0"><col style="width: 171pt;" width="228"> <col style="width: 72pt;" width="96"> <tbody><tr style="height: 19.5pt;" height="26"> <td style="height: 19.5pt; width: 171pt;" width="228" height="26">Red Apple Green</td> <td style="width: 72pt;" x:num="" x:fmla="=IF(ISERROR(SEARCH("green",A1)),2,1)" width="96" align="right">1</td> </tr> <tr style="height: 19.5pt;" height="26"> <td style="height: 19.5pt;" height="26">Orange Pear Blue</td> <td x:num="" x:fmla="=IF(ISERROR(SEARCH("green",A2)),2,1)" align="right">2</td> </tr> <tr style="height: 19.5pt;" height="26"> <td style="height: 19.5pt;" height="26">Blue Green Orange</td> <td x:num="" x:fmla="=IF(ISERROR(SEARCH("green",A3)),2,1)" align="right">1</td> </tr> </tbody></table>