categorize items

  1. A

    How to

    Hi i have monthly exercises in my work to find the missing data in two sheets (sheet A and sheet B) and categorize them (for example Hotel, Restaurant, Offices) i want to create an Excel file to find the missing data between two sheets and the result should be showing the missing in each sheet...
  2. Q

    categorize text strings by keywords and their synonyms with textjoin, if, countif

    Hi, I'm trying to automatically categorize a large amount of products by finding keywords in the product descriptions. Using a textjoin, if, count if fucntion works perfectly because if mutiple keywords match, it indexes all of them. But these products come from a range of different suppliers...
  3. M

    Merging Rows of Data

    I'm wondering if this is really a Power Pivot question rather than a pure Excel question. I've installed Power Pivot but never used it. Here's the challenge: There are 11,000 rows of which 4,000 are unique. Each entity shows up 1 to 15 times depending on how many orders they've placed. The...
    • Monsignor
    • Thread
    • categorize columns categorize items combine rows
    • Replies: 5
    • Forum: Power Tools

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