massive

  1. R

    Difference of Column with Multiples of the Same Entry

    I want it to take the difference of one 1 column minus a certain box and add together only 1 unique value since theres multiples of the same entry. I had SUM(E8:E50)-L4 Which worked until column E had several entries with the same value. Then it added column E together so the number was...
  2. M

    Multiplication formula

    Hi all, i have searched the web for a formula that would allow me too multiply the first 10,000 of a number in a cell by 0.45 and the remainder of the number by 0.25 then ideally putting it into 2 separate cells ( one for the 0.45 answer and the other for the 0.25 answer . Although its not a...
  3. T

    How to hide many pivotitem at once

    Is there a way to hide a list of PivotItems in a single command? Using Excel2010, standard pivot (not OLAP data source) I'm looking for a way to significantly speed up the code execution. NB I already suspended the recalculation, the video refresh, set .ManualUpdate = True, ... So I'm...
  4. G

    Multiple measures on a line chart?

    Is there a straightforward way to do this? Clearly I could union two tables together, but that seems a massive pain. I just want to drag two measures into the value area of a line chart!
  5. C

    Massive 300MB Spreadsheet why?

    Hi, I've been given a 300MB spreadsheet and asked why is it so large? Where do I start? Any help would be appreciated.

Watch MrExcel Video

This Week's Hot Topics

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
Top