Скачать или смотреть Dynamic Named Ranges For MS 365

If you're using MS 365, watch this video to see an alternate method for creating Dynamic Named Ranges.
Watch Next
   • Dynamic Summaries In Excel  

Link To View Workbook
https://docs.google.com/spreadsheets/...

Direct Download Link
https://drive.google.com/uc?export=do...

Excel Version
Recorded using online Excel 365 but should work with desktop version of 365
MS 365 gets regular updates and in some cases, new functions, which could make this solution simpler or even different.

Excel Tips Playlist
   • EXCEL TIPS  

About
In a previous video I showed how to create Dynamic Named Ranges that automatically adjust to include added rows and columns without needing to change formulas. And it works with both Standalone Excel and MS 365. In this video I show an alternate method that is specific to MS 365.