impossible?

  1. M

    Copy Rows of info until next non empty row

    Good day everyone, Trying to have a button ( or multiple if needed ) that when clicked will be able to copy A2:F6 ( for example ) and paste in different range. But i also need it to be able to then select the info associated to the next name in column A and copy paste that one. The tricky part...
  2. F

    Counting Overlapping Dates

    Been working for a hour and can not come up with a working formula. I want to have a total of time each date range over laps for each day on the left (I put in a couple numbers just to demonstrate).
  3. E

    Is this possible? Adding equations and formulas to pivot tables

    Background: I am "analyzing" data from a large table, for simplicity, I made a dumby excel spreadsheet. My data records races and which place the runner came in. I have uploaded a photo as a visual aid. My goal: To create a pivot table the accurately returns the win rate of the race...
  4. N

    Advanced Formula - If statement + weeks in months - Impossible?

    Hi, I've put together this formula. =IF([@[NOV-17 Finished Goods SO Demand]]>[@[VARIABLE SO Months Average]], ([@[QTY IN STOCK]]+[@[QTY ON ORDER NOV 17]])-[@[NOV-17 Finished Goods SO Demand]], ([@[QTY IN STOCK]]+[@[QTY ON ORDER NOV 17]])-[@[VARIABLE SO Months Average]]) It works, but I need...
  5. C

    Formula to Determine Sales Percentages - But Not That Simple

    We normally report sales as Total Goal & Total Digital Goal against Total Actual Sales & Total Actual Digital sales, weight both at 50% add them together then take that percentage and give a base percentage with an accelerator for any amount over. For example: <tbody> Goal Actual % to Goal...
  6. L

    Insert text from a cell in another worksheet

    Hi I am trying to insert text from cells in another worksheet as follows: I have a front sheet named "Front Sheet". Column A is already populated with a list of company names. Column B is for Contact names, Column C is for email address. Each company has its own worksheet, and is named as...

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