View Single Post
  #1   Report Post  
Anna
 
Posts: n/a
Default Categorizing an excel column

I have an excel spreadsheet. In column A, is a list of 15,000 phrases
consisting of 5-7 words.

Last night, I was going to go through each phrase in the list, look for
keywords and if it contained it, I would enter the keywords in the adjoining
columns. This would be quite tedious.

Is there any simple way for me to categorize this list using macros or some
third party addon.

As an example, lets say I wanted to to categorize the list based on race,
religion, sex, and country of origin. I would enter specific criteria in
the macro such as race could equal white, black, asian, indian, religion
could equal christian, jewish, muslim, sex could be m or f and country of
origin could be America, or Europe.

The macro would look for these specific words in each of the phrases and if
the phrase contained those keywords, it would tag that phrase by putting the
keyword in the adjoining columns.

The end result would be as follows:

One phrase would be White Christian male teacher. Using the above example,

Column B next to this phrase would contain white
Column C next to this phrase would contain christian
Column D next to this phrase would contain male
Column D next to this phrase would remain blank as it doesn't have any
criteria defined in the macro

Thank you in advance for any help provided.

Jason