Dynamic dropdown – examples1 DownloadThe tutorial shows how to create an Excel drop down list depending on another cell by using new dynamic array functions. Creating a simple dropdown list in Excel is easy. Making a cascading drop-down has always been a problem. The above linked tutorial describes four different approaches, each including a crazy number of steps, a bunch of different formulas, and a handful of limitations relating to multi-word entries, blank cells, etc. Here is the post. Download Now!
Download Tag: excel
Azure Resource Naming Convention Generator Template
Azure Resource Naming Convention Generator Template21 DownloadsEach resource or service type in Azure enforces a set of naming restrictions and scope; any naming convention or pattern must adhere to the requisite naming rules and scope. For example, while the name of a VM maps to a DNS name (and is thus required to be unique across all of Azure), the name of a VNET is scoped to the Resource Group that it is created within. This spreadsheet helps you to define the name (URL) for each resource. Download Now!