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
-
DVR
Tate Speech by Andrew Tate
1 hour agoEMERGENCY MEETING EPISODE 113 - THE NEXT STAGE
9.95K16 -
1:19:40
JULIE GREEN MINISTRIES
2 hours agoTHE GREAT FALL OF THE BANKING SYSTEM AGAINST THIS NATION
32.1K124 -
LIVE
LFA TV
14 hours agoLFA TV ALL DAY STREAM - MONDAY 8/11/25
6,439 watching -
LIVE
Chicks On The Right
3 hours agoMTG fighting w/Levin, Pritzker humiliated by Welker, Mamdani squeals like a girl, and psychotic libs
1,769 watching -
LIVE
The Bubba Army
2 days agoAlligator Alcatraz Closed?! - Bubba the Love Sponge® Show | 8/11/25
3,891 watching -
29:03
DeVory Darkins
15 hours ago $6.40 earnedDemocrat Governors painfully HUMILIATED Trump drops BRUTAL WARNING for DC officials
7.03K56 -
14:44
Preston Stewart
18 hours ago $1.15 earnedTrump's Cartel Crackdown
5.08K6 -
1:05:58
Sarah Westall
15 hours agoForces Creating Massive Instability Worldwide: US, Ukraine, China, Israel, Colonel Douglas Macgregor
15.3K33 -
2:02:19
BEK TV
2 hours agoTrent Loos in the Morning - 8/11/2025
6.22K -
3:45:16
Badlands Media
1 day agoThe Narrative Ep. 34: The World Eater
111K41