LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel XP - 2 Column Pages MarkC New Users to Excel 3 June 20th 05 06:45 AM
Excel: is it possible to move column contents into a line Ginger Excel Discussion (Misc queries) 2 June 16th 05 06:59 PM
Column A is Town, Column B is names. How can Excel add & tell how. Cindy Charts and Charting in Excel 3 January 13th 05 07:27 PM
How do I sort a column of formulas in Excel? Gordon Excel Discussion (Misc queries) 2 November 27th 04 01:55 AM
Excel - option to extend function in cell to column kjoshua777 Excel Worksheet Functions 2 November 18th 04 01:08 AM


All times are GMT +1. The time now is 09:42 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"