brands

  1. S

    VBA to count

    <tbody> c m brand 1 2 brand 4 1 brand 4 1 brand 1 3 brand 7 1 </tbody>...
  2. R

    Looking for a way to allocate values according to a percentage split, plus a couple other variables in VBA

    Hello everybody! (HI DR. NICK!) I'm after a semi-intelligent automated solution to a manual task one of our directors does, he goes through a list of 1,000 clients each week and assigns a brand to them based off a bunch of variables and calculations he performs -imperfectly- on the spot. On...
  3. F

    SUMIF with multiple criteria

    Hi Everyone! Long time lurker, first time poster. I'm hoping someone can shed some light on a problem I'm facing with a summary sheet. I have a large set of data that includes: brands, employees (that may or may not work under multiple brands) and their commissions earned from each brand. Ex...
  4. A

    Combining 2 Pivot Tables

    Hi I have 2 data tables. One shows transactional actual sales data across multiple brands and the other table contains budget data for multiple brands - summarized at brand level. What I would like to do is combine these 2 tables into one pivot table to display Actual vs Budget. Reason I...
  5. A

    P&L lookup to be done through formula for data segregation

    I have to segregate a consolidated P&L, in which I have PY, CY, BUD for one brand followed by another brand and there are almost 50 brands. What I have to do is I have create a master table where in I will put in the Brand name and it should reflect the information for that brand. G1, H1& I1...
  6. F

    Formula to skip a certain value and continue on the sequence

    Hi everyone! First time reaching out for help, I have a sequence in column A and would like to pull the data into column B. But the thing is I would like to skip over the cell if it states "All Other" yet continue on the same sequence. I remember writing a formula a while ago for this, had some...

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