categorisation

  1. 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...
  2. C

    Grouping Percentages

    Hi Guys, I am wondering if anyone could assist with finding a formula to group various percentages into the different percentage groups. For example "Less than 0%", 0-5%,5-10% and, "More than 15%" Thanks
  3. M

    Varying category types within column

    Hi. I have received an excel workbook with about 2,000 products which need to be exported into a CSV format for use in a MySQL web store. My problem is that the way in which the spreadsheet is formatted seems to use the same column for multiple categories of data. For example, column A...
  4. E

    Data categorisation based on keyword

    I have to categorise a large volume of data in order to analyse it. I need to categorise it based on the text in the offer column. Is there a way of doing this based on keywords? Here is some example data with an explanation of what I’d like to be able to do below: <TABLE style="MARGIN: auto...

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