LOOKUP ALL values b/w two dates (Excel Dynamic Arrays Filter Function to return many match results)
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
Видео LOOKUP ALL values b/w two dates (Excel Dynamic Arrays Filter Function to return many match results) канала Leila Gharani
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
Видео LOOKUP ALL values b/w two dates (Excel Dynamic Arrays Filter Function to return many match results) канала Leila Gharani
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
Excel Sum(ifs) between dates, sum month & sum with multiple criteriaExcel Dynamic Arrays (How they will change EVERYTHING!)SURPRISING Advanced Filter TRICK in Excel (You've Never Heard Of!)Advanced Filter in Excel VBA | Extract Data between dates in HindiReturn Multiple Match Results in Excel (2 methods)Excel Date Filter Magic - Last Month, This Month, YTD & More + Awesome InterfaceAdvanced Pivot Table Techniques (to achieve more in Excel)When Should you Use the Hash Sign (#) in Excel Formulas?Excel Magic Trick 894: Extract Records Between Two Dates: Filter or FormulaSUPER EASY Excel Data Entry Form (NO VBA)INDEX MATCH Explained (An Alternative to VLOOKUP)How Power Query Will Change the Way You Use ExcelExcel Calendar with Just ONE Formula!Excel Lookup to Return Multiple Values with FILTER FunctionExcel SUMIFS (better version of SUMIF), COUNTIFS & AVERAGEIFS (Multiple Criteria)3 EASY Ways to Find and Remove Duplicates in ExcelExcel DGET Function Solves 2 of Your VLOOKUP ProblemsCreate SMART Drop Down Lists in Excel (with Data Validation)Excel for Accounting - 10 Excel Functions You NEED to KNOW!