I am trying to look through 1column in a large spread sheet for certain key
words. i would like to group the rows of the sheet using these key words. the
column i am searching has many words in it, not just the key word.

currently, we use a find that highlights the field with a specific color if
it contains the key word. We then create a blank column next to this searched
column Using visual inspection based on the color, we populate this new
column with a number that allows us to sort the entire sheet, therfore
grouping the rows by key word.

does anyone have a faster way? the visual inspection and population of the
adjoining column is time consuming. find a replace does not work, because the
fields ion the search column contain many words, so only the key word gets
replaced.