promotion

  1. J

    Sumproduct with subtraction

    Hello I'm am trying to get sumproduct to subtract values in a column that match the criteria of the formula I have a check register that and each entry has a category, Payee, Spent, Received, Balance <tbody> CATEGORY PAYEE SPENT RECEIVED BALANCE Venue Tom thumb 125.00 500.00 Promotion...
  2. S

    Active sales promotions per week

    Hello dear Excellers! I'm posting here after hitting a wall with Excel for an awful amount of time, and despite my nature of not giving up easy, I had to post this thread. The problem I have an imported table which consists of information about sales promotions. What I'm currently looking...
  3. U

    Compare 2 columns and delete all junk.

    Hi, my English is not good but I will try. I have a reference column with products and I want to compare it with another column and delete all text that is not related to the control column. Example... LG G6 .................... LG G6 New promotion Samsung C5 .......... Samsung C5 Deal offer...
  4. T

    Format Hierarchical Pivot Table x-axis labels

    https://drive.google.com/open?id=0Bzz1wn6UL_b6NzdEUWdhTEkwdUE In thePivot chart above, there are 3 levels of labels, coming from the Pivot Table. <tbody> 1st Level: : Month's names 2nd level: Promotion / No Promotion 3rd Level: Names of Sales Promotions </tbody> I need to...
  5. T

    Formula to find the earliest date that maches a name, but when the column has 1 as a date?

    Ok I'll try explain this, I need a fformula that can return the start date of a promotion we are doing by look for the promotion name and finding the first date now here's my big problem, some times part of the promotion has no date, so the formula that calculates the start date returns...

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