dynamic formula range

  1. M

    Speeding up my process with Dynamic formula for Excel Online

    hi friends! I currently am sorting my sheet like the attached page. Basically I have a few unique numbers, want to add a comment next to it, then lookup the value against full columns where the number exists in the data table in col I&J. Then I want to add the comment to each replicate of the...
    • Mooncake1
    • Thread
    • dynamic formula range excel online formula slow formula
    • Replies: 2
    • Forum: Excel Questions
  2. P

    Apply conditional formatting dynamically

    Hello everyone, I have to validate some data tables on regular basis. which I do with the help of index+match+match function and it work pretty well. Now over time I am getting tons of workload and want to introduce VBA in some of those. My question have two parts. 1) I want to apply conditional...
  3. A

    dynamic formula for asset depreciation expense

    Hi all, I am working on a formula to calculate straight line asset depreciation expense for each year from 2016-2022. Every year the company purchases some amount of new assets. I would like the term that assets depreciate to be based on an input cell (A1), so I need the depreciation expense...
    • Adam1988
    • Thread
    • depreciation depreciation expense dynamic formula range
    • Replies: 5
    • 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