课程: Excel for Financial Planning and Analysis (FP&A)

今天就学习课程吧！

今天就开通帐号，24,700 门业界名师课程任您挑！

Using INDEX XMATCH for dynamic ranges

拉拉似穷人版卡戴珊？球场郁闷情场甜瓜 

课程: Excel for Financial Planning and Analysis (FP&A)

开始一个月试用 购买团队方案

Using INDEX XMATCH for dynamic ranges

“ 百度 为确保述职报告质量，我们建立了逐级审核机制，对汇报成绩有“水分”、查摆问题不深入、下步打算不清晰的，一律退回重写。

- [Instructor] In addition to dynamic tables, as I've shared with you INDEX and MATCH, and INDEX plus XMATCH, continue to be among the easiest, cleanest, and fastest ways to build dynamic ranges. So what does a dynamic INDEX range allow you to do? Well, it allows for the dynamic referencing of expanding and contracting data sets, prompted by user inputs and toggles. As you can see over here in cells N2 and N3, I have a couple of data validation dropdowns. Well, how did I do this? If I go up to my data ribbon and I go over here to data validation, I click this icon, this window pops up, and it says allow a list, and my source is specifically going to be B6 all the way over to M6, it's the range of dates. Let's go back over. Now, when I select this dropdown, you can see that I have my list of dates all the way from January down to December. Now, if I put my cursor on each one of these formulas, you'll recognize the…

内容