Premium Only Content

LOOKUP ALL values b/w two dates (Excel Dynamic Arrays Filter Function to return many match results)
13 Jun 2019 Excel for Office 365 & Dynamic Arrays
Take advantage of the new Excel dynamic array functions to create interactive Excel dashboards really fast. To maximize the potential of the new Excel functions, check out the complete course: https://courses.xelplus.com/p/excel-dynamic-array-formulas
UPDATE 2020: Dynamic arrays are now available in Excel for Office 365.
Tutorial Summary:
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.
This is a knowledge packed tutorial covering the different aspects of dynamic arrays and Excel's new calculation engine.
⯆ DOWNLOAD the workbook here: https://www.xelplus.com/excel-dynamic-arrays-filter-function-all-records-between-dates/
LINK to Advanced Filter Feature: https://youtu.be/VqQACB_69SQ
LINK to dynamic array playlist: https://www.youtube.com/playlist?list=PLmHVyfmcRKyyPFY31LldHWcJdLzGUPTSP
★ My Online Excel Courses ► https://courses.xelplus.com
✉ Take this Quiz to choose the right Excel course: https://www.xelplus.com/course-quiz/
EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/
Get Office 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593
GEAR
Camera: https://amzn.to/2FLiFho
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Microphone: https://amzn.to/2DVKstA
Lights: http://amzn.to/2eJKg1U
More resources on my Amazon page: https://www.amazon.com/shop/leilagharani
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#MsExcel #Excel #LeilaGharani
-
LIVE
Streamstorian
1 hour agoRPG Saturday | Chrono Trigger!
245 watching -
LIVE
ttvglamourx
1 hour agoSURPRISE SATURDAY STREAM !DISCORD
101 watching -
LIVE
RaikenNight
3 hours ago $3.09 earnedLets Get Our Hunt On!! Then We Build Some Warhammer Minis
240 watching -
LIVE
Bare Knuckle Fighting Championship
3 hours agoCountdown to BKFC FIGHT NIGHT MANCHESTER & FREE LIVE FIGHTS!
122 watching -
LIVE
Sm0k3m
2 hours agoIcarus
93 watching -
LIVE
Flexible Games
2 hours agoChilling in Vintage Story 1.20 MP
96 watching -
LIVE
Pepkilla
4 hours agoYour favorite Asian ~
181 watching -
31:28
CatfishedOnline
17 hours agoWoman INSISTS Boyfriend Is Trapped Overseas Or Romance Scam?
26.3K11 -
4:39:06
CassaiyanGaming
14 hours agoSaturday | Prince of Persia - 8am central
44.6K3 -
LIVE
Scottish Viking Gaming
2 hours ago💚Rumble :|: Saturday Special :|: I LOVE THIS RUMBLE SHIT!!
99 watching