All articles with 'dynamic arrays' Tag

Ever wanted to make a random sentence or text? You can use Excel formulas to make totally random sentences. This is a great way to generate test data or dummy data-sets.
Continue »{ 43 Comments }
Excel Basics: How to add drop down list to validate data
Published on Sep 27, 2019 in Learn Excel

Validating your data as you type can prevent any surprises when you are doing analysis / follow-up on the data. Thankfully, excel has the right tools to do it. Excel drop down list can assist you in picking up a value from a valid list to enter in a cell. Here is a short how-to […]
Continue »