subcategory

  1. J

    Pivot table - show items with no data maintaining subcategory

    Hi, I have a table that I use to track my expendings every year. I have three main categories (Taxes, Recurring Expenses and Atypical Expenses). Under each category, I have a number of expenses, like this (I'm making this up, since I'm from Brasil and taxes and expenses are different than in...
  2. S

    Dynamic Formula Help

    This seems as though it should be simple but I am not getting it. 1. Category Names are Data Validation lists. 2. If user selects Subcategory from the Data Validation list that cell becomes a Subcategory of the category in the cell above. 3. If Subcategory chosen, Sum Total to automatically...
  3. I

    Reset count for one column while checking another to trigger reset

    I have three columns articulated as below: Cetegory | SubCategory ID | Subcategory Cat 01 0001 SubCat1 0002 SubCat2 Cat 02 0001 SubCat3 0002...
  4. J

    VBA: Filter rows for text, set filtered rows to Bold font

    I have searched quite a bit and can't put the answer to this one together. I have a spreadsheet similar to this: <tbody> Group Built Price Fee Main Group 1 Abcdefg 426 $ 903.58 $ 2.12 Subcategory A 157 $ 277.58 $ 1.77 Subcategory B 125 $...
  5. C

    Create new supplier rows based on subcategory/category levels

    The purpose is to identify EVERY possible missed commodity code a supplier should have been mapped to that falls under CATEGORY or SUBCATEGORY level. Ideally the script will only add the ones that are missing, but if it is easier to dump ALL COMMODITIES that are under the Subcategory that will...

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