I might not post many Excel snippets, but I’m collecting them into a small Excel Snippets series to make them easy to find.
This is based on an example a colleague discussed with me for dynamically calculating the sum of a range of columns based on the user specificed number of months.
The data for the months of the year was going across the worksheet with a total at the end, but he only…
Continue Reading Ian Grieve’s Article on their blog
Excel Snippets: Offset Formula to Calculate Range on Number
I might not post many Excel snippets, but I’m collecting them into a small Excel Snippets series to make them easy to find. This is based on an example a colleague discussed with me for dynamically calculating the sum of a range of columns based on the user specificed number of months.
Blog Syndicated with Ian Grieve’s Permission
More About This Author
Array
Dyn365GP2023.05.30SQL Scripts for Microsoft Dynamics GP: Select a List of Vendors- Dyn365GP2023.05.29SQL Scripts for Microsoft Dynamics GP: SQL View to Create Division, including UDF 3 and 4, Tree for Management Reporter
Dyn365GP2023.05.29In Microsoft Dynamics 365 Business Central (Financial), how do I… Remove Dimension Combination
Dyn365GP2023.05.28ClassicPress Plugins Available From azurecurve | Development in 2023: Load Admin CSS
