Category:

Course Description:

This video shows a practical example of using Excel’s new Dynamic array functions to create a report that shows all records that fall between two dates. You learn: 1. How to use Dynamic array (# hash referencing) in data validation 2. How to create an Excel dependent drop down list 3. Create a FROM and TO Date drop down list where the TO date occurs AFTER the from date 4. Use the new Dynamic array SORT and UNIQUE functions 5. Use the new Excel Dynamic array Filter function (new Excel lookup formula) to return multiple match results 6. How to do an AND logical test with the Filter formula to return all values between two dates. Course Length: 9:12 minutes Source: Leila Gharani

Thousands of courses

DisclaimerMany of the curated courses have been manually added into our Learning Management System, then enhanced with structure, descriptive, activities and consolidation,  referencing who the content creators are (where required). If you like the curated content from any creator and like their materials, please feel free to connect with them directly to explore their full libraries of paid programs. 

We will continue to add more curated quality content as well as increasing partnerships with creators to provide you with an all-in-one skills development platform. 

Book a demo now!

Tell us a bit about you. After review, you will receive an invite calendar where you can select your demo time.