moving range

  1. S

    Lookup multiple cell values in a specific range

    Hello all, Any help on solving my excel nightmares would be much appreciated. The relevant columns of my dataset look like this: <tbody> 1 V W X BA 2 50 1 0 51 3 51 0 0 4 52 0 0 5 68 1 0 72 6 69 1 0 7 70 1 0 8 71 1 0 9 72 0 0 10 73 0 0 </tbody> I need a formula that...
  2. J

    Create a Dynamic Moving Range

    Hi All, I've created a dynamic range so that my graph will automatically grow whenever my macro runs and adds a new week of data to my table. However, now I'd like to have the graph show only the previous 6 months of data. I know I can do this by resetting the reference cell in my range every...

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