dynamic range names

  1. C

    Dynamic name for a dynamic range

    Does anyone know how to dynamically change the name of a range? Say a range was called Apples which is taken from the column header and I wanted to change it to Pears by changing the column header. Is there a way to do this?
  2. M

    Dynamic range in one column based on value in other column

    Dear all, I have a relatively simple challenge to add a dropdown, with a dynamic range, in Excel that shows values of column A that meet a criterium in column B. Column A Column B 1 Mark - Tree 2 Richard - Tree 3 Mary - Apple 4 Joe - Tree...
  3. S

    Dynamic Ranges in Excel 2007 Charts

    Hi, I am trying to use dynamic ranges in an Excel 2007 chart. I can define the ranges in the worksheet - i.e.: By_Plant - =OFFSET(Analysis!$A$2,0,0,COUNTA(Analysis!$A:$A)-1,) This works fine, but I can't seem to incorporate either the range name or the offset formula in my chart. If I use...
    • sturcol
    • Thread
    • charts dynamic range names excel 2007 offset formula
    • Replies: 2
    • Forum: Excel Questions

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