categorization

  1. A

    Macro to search and categorize items

    I have a large list where I'm trying to put everything into family categories. As an example, if I have the following list, a person could go through and identify that there are families of parts: ABC, ABCD, CDE, CDF, and ZZ. Sometimes the families are identified by the first 3 characters...
  2. D

    Multiple categories based on keywords and values

    Hey folks, Kinda new to this excel thingy so excuse me for being dumb I have about 40,000 products and over 60 categories (or more based on how things are going) is it possible to use a set of defined texts as keywords and show them as categories with , between them? ex: if this cell have these...
  3. O

    [VBA] Create categories in Excel including or excluding certain keywords?

    Hi, I've just signed up because I'm struggling with a categorization problem and hope that I can find some help here. I need to categorize a list of items, depending on whether they contain some keywords and at the same time do not contain others. These are the categories that I need to create...
  4. U

    Formula for looking up keywords and entering text in another column if a certain keyword is found.

    Hi guys! I need a formula or a script which will check a if a cell contains keywords from a list in another sheet. If a keyword is found, it will populate the cell next to it with the "category" set for that keyword. So I have a sheet which is called "Keywords" which contains the keywords to...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top