Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Gather multiple keyword and separate them to categories
Hi everybody
Please help me The example.xls file is located :http://www.box.com/s/ibrceu93p3c7taxdgxl6 Excel 2010 So my problem I?ve 4 column table, let say source, in worksheet?source?. These tables comes from different companies. Unfortunatelly they have similar products, but mostly those has slightly different names. In this screen you can see one of the possible company's product list. http://static.kepfeltolto.com/big/20...19d737786d.jpg What I need, a macro which is gather the predefined text variatons by me from cells of column ?A?, for eg: Xigmatek NRP-PC602 X igmatek NRPPC Xigmatek NK-602 ab cde Xigmatek Kp-12456...etc. ...decide match or not, if so, add the result to column ?E? in "required result" worksheet in specified item of category. http://static.kepfeltolto.com/big/20...33fb5464e0.jpg The main key is, I would like to determine what text variations(product's specifiaction) belongs for which category. Is it makesense??Maybe is it possible way, I just wondering.. generating somehow for e.g.: if text found "toner or tonerxyz or other text contatains toner" then add column E value: "Inkjet" as category in worksheet "reqired result" in same row... Briefly i'd like to separate automatically the items and send them to the approprieate category.(In other words: What I want in excel it is called ?price routing? what price comparison script does, and I wish to remodeling how these process works in excel.) If anybody have a best approach how can I solve this problem and abopt this method the rest of companie's tables with macro or pivot table I would be appreciated. What is usual way? How can I reduce this tedious work??(in this case I have about 15000 row) Thanks in advance, for your kind effort |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Gather multiple keyword and separate them to categories
Have you considered using the menu Data | Filter? Using a custom
filter on column A, you can filter based on the Product Name containing a particular characters string. If you want a macro, use Record New Macro and then edit it to suit your goal. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Gather multiple keyword and separate them to categories
On Feb 24, 8:25*am, merjet wrote:
Have you considered using the menu Data | Filter? Using a custom filter on column A, you can filter based on the Product Name containing a particular characters string. If you want a macro, use Record New Macro and then edit it to suit your goal. I'm still not quite sure what you want in col E. Send a file to dguillett1 @gmail.com with a complete explanation. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Gather data from multiple excel files into one master excel file | Excel Discussion (Misc queries) | |||
Charting Multiple Categories | Excel Discussion (Misc queries) | |||
Gather data from multiple XML sheets? | Excel Programming | |||
Gather data from multiple excel files in mutiple folders | Excel Programming | |||
SUMIF With Multiple Categories | Excel Worksheet Functions |