dynamic columns

  1. K

    Power Query - Function (Average Daily Balance) - Repeat for Each Dynamically Named Column and Dynamically Changing Number of Columns

    Hello, It has been a very long time since I have posted on here, so I apologize in advance if I am rusty on any preferred protocol and information/data to include on a post. I need to be able to able to obtain the average daily balance of each case, for each quarter. Since I have not found a...
    • KnightFhawker
    • Thread
    • average daily balance daily balance dynamic columns dynamic name dynamic number of columns excel function list.accumulate list.generate loop power query repeat running total
    • Replies: 7
    • Forum: Power Tools
  2. R

    dynamic row and column lookup

    I am working on a worksheet to lookup values from a table. I am having a problem figuring out the row and column dynamic lookup. I have two pieces of information. For example, 4 and $21,000. With these two pieces of information I need to be able to look across the top row to determine where 4...
  3. C

    Showing Columns Dynamically using Slicer

    Situation: Aggregate queries. Rows are accounts, Each column represents up to 36 summary financial periods. There is no time dimension Currently users have to change values every month - which can mess with formatting. Wondering of a way to dynamically show a particular period value in a...
  4. C

    Dinamic charts in many sheets in one workbook excel 2003 vba

    Hi: I have the code below almost finished (there are 2 macros the first one , Macro4, does the charting perfectly in sheet1) and the second macro, Macro 5, makes the macro 4 repeat itself in each sheet of my workbook except for the first sheet. However when I attempted to run the macro 5 I...

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