1. T

    How do I redistribute sales fairly if I want to increase the growth percentage?

    I am working on a sales forecast for 2020. The forecast has 92 locations and I have sales by week by site for Period 1 2019 and a forecast of sales by week for Period 1 2020. Period 1 2019 Sales Total: $11,586,579 Period 1 2020 Sales Forecast: $11,57,090 Dollar Change in sales 2019 to 2020...
  2. N

    Dynamic Drop-Down list

    Good Afternoon all, I am in need of assistance. I am trying to create a dynamic drop-down list based on another drop-down list. I have hundreds of rows of distributors in Column B and the markets they belong to in Column A. I can put the list of distributors into the drop-down, but what i...
  3. B

    Distribution of a string into columns without text

    How can I distribute PB4-440-20-560-25-785-30-AGP-875-35-1050-40-GP-1170 of Cell A1 into various columns such as B1, C1, D1, E1, F1, .....etc. without text strings such as AGP, PB4, GP etc.by using excel formula?
  4. O

    Distributing value automatically across cells

    i have line load in column B, but the line in capped to 100 kW so the load more than 100 kW should be shifted to the cells where the load is less than hundred (can be seen in column D). from the table, we see the accumulated load to be shifted is 25 kW. this should be shifted to the cells...

Some videos you may like

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...