Dynamic array formulas in Excel
exceljet.net
Dynamic array formulas in Excel
Dynamic Arrays are the biggest change to Excel formulas in years. Maybe the biggest change ever. This is because Dynamic Arrays let you easily work with multiple values at the same time in a formula. This article provides an overview with many links and examples.
8 months ago
Excel Name Manager
Name Manager - How to Create a Named Range in Excel 2013|2016
4:48
Name Manager - How to Create a Named Range in Excel 2013|2016
YouTubeExcel Destination
22.1K viewsOct 2, 2016
Use Name Manager to edit or delete named ranges in Excel #exceltips
0:56
Use Name Manager to edit or delete named ranges in Excel #exceltips
YouTubeExcelDoctor
2.6K viewsNov 18, 2024
How to Create Named Range in Excel - Office 365
2:30
How to Create Named Range in Excel - Office 365
YouTubeFind Easy Solution
137.1K viewsSep 10, 2020
Top videos
Return array with INDEX function
Return array with INDEX function
exceljet.net
May 14, 2024
VLOOKUP with variable table array
VLOOKUP with variable table array
exceljet.net
Jun 12, 2021
Lookup Multiple Values from an Array | #Excel 365 Version Unique List of EMP ID: =UNIQUE(Data[Emp ID]) Lookup EMP Names: =XLOOKUP(B24,Data[Emp ID],Data[Name]) Fetch Multiple Values from an Array: =TEXTJOIN(", ",TRUE,IF($B24&D$23=Data[Emp ID]&Data[Date],Data[Groups],"")) | Excel Basement
1:00
Lookup Multiple Values from an Array | #Excel 365 Version Unique List of EMP ID: =UNIQUE(Data[Emp ID]) Lookup EMP Names: =XLOOKUP(B24,Data[Emp ID],Data[Name]) Fetch Multiple Values from an Array: =TEXTJOIN(", ",TRUE,IF($B24&D$23=Data[Emp ID]&Data[Date],Data[Groups],"")) | Excel Basement
FacebookExcel Basement
4.7K viewsNov 1, 2023
Excel Dynamic Named Ranges
🔗 Create dynamic named ranges in Excel that grow with your data. Use OFFSET COUNTA to auto-expand your named ranges—no updates needed as rows change. Perfect for dropdowns, forms, and reports that stay in sync. Want to master smarter Excel setups like this? 👉 Join the community: https://www.excelforfreelancers.com/op/be-part-of-our-excel-community/ #exceltips #excelautomation #namedrange #excelforfreelancers #productivityboost | Excel For Freelancers
1:00
🔗 Create dynamic named ranges in Excel that grow with your data. Use OFFSET COUNTA to auto-expand your named ranges—no updates needed as rows change. Perfect for dropdowns, forms, and reports that stay in sync. Want to master smarter Excel setups like this? 👉 Join the community: https://www.excelforfreelancers.com/op/be-part-of-our-excel-community/ #exceltips #excelautomation #namedrange #excelforfreelancers #productivityboost | Excel For Freelancers
FacebookExcel For Freelancers
868 views8 months ago
Dynamic named range with OFFSET
Dynamic named range with OFFSET
exceljet.net
Feb 6, 2025
Dynamic Named Ranges in Excel
4:00
Dynamic Named Ranges in Excel
vertex42.com
Oct 11, 2017
Return array with INDEX function
Return array with INDEX function
May 14, 2024
exceljet.net
VLOOKUP with variable table array
VLOOKUP with variable table array
Jun 12, 2021
exceljet.net
Lookup Multiple Values from an Array | #Excel 365 Version Unique List of EMP ID: =UNIQUE(Data[Emp ID]) Lookup EMP Names: =XLOOKUP(B24,Data[Emp ID],Data[Name]) Fetch Multiple Values from an Array: =TEXTJOIN(", ",TRUE,IF($B24&D$23=Data[Emp ID]&Data[Date],Data[Groups],"")) | Excel Basement
1:00
Lookup Multiple Values from an Array | #Excel 365 Version Unique …
4.7K viewsNov 1, 2023
FacebookExcel Basement
Array by name, Array by nature. Curate a vanity designed for your needs and your space – with our adaptable range of sizes, styles, colours and finishes. Explore the range in our showroom. Available to purchase from all leading plumbing merchants. #athena #bathroomware #newzealand | Athena Bathrooms
0:23
Array by name, Array by nature. Curate a vanity designed for your …
53.5K views5 months ago
FacebookAthena Bathrooms
INDEX Function
INDEX Function
Aug 30, 2024
exceljet.net
Dynamic Arrays in Excel 365
Dynamic Arrays in Excel 365
2.9K viewsFeb 8, 2022
YouTubeSONICVideoTraining
MS Excel - Match Function
1:15
MS Excel - Match Function
779.5K viewsJan 15, 2018
YouTubeTutorialsPoint
5:52
The Excel TRANSPOSE Function
466.3K viewsDec 7, 2020
YouTubeTechnology for Teachers and Students
1:01
How to use VLOOKUP in Excel
4M viewsNov 25, 2019
YouTubeMicrosoft 365
6:30
VLOOKUP & HLOOKUP in Excel Tutorial
793.7K viewsMay 21, 2018
YouTubeKevin Stratvert
11:04
Google Sheets - Combine Data From Multiple Sheets (Tabs) Tutorial
697.4K viewsSep 22, 2017
YouTubeLearn Google Sheets & Excel Spreadsheets
14:56
How to Use SUMPRODUCT in Excel
824.3K viewsApr 13, 2016
YouTubeLeila Gharani
5:19
Array Formulas in Excel
13.3K viewsSep 10, 2012
YouTubeLearnChemE
3:46
VLOOKUP 4 Using absolute cell reference
33.2K viewsSep 30, 2015
YouTubegenos onlygirl
2:58
How to use the VLOOKUP function in Excel
5M viewsSep 28, 2018
YouTubeTechOnTheNet
5:36
Matrix Math/Excel-1
161.9K viewsMay 7, 2012
YouTubeLearnChemE
4:01
Dynamic Named Ranges in Excel
29.2K viewsOct 11, 2017
YouTubeVertex42
16:30
15 Expert SUMIFS Function Examples in Excel - Simple to Adv…
185.5K viewsFeb 14, 2018
YouTubeTeachExcel
2:34
How to use the SUMIF function in Excel
1.5M viewsOct 2, 2018
YouTubeTechOnTheNet
16:57
3 Advanced Examples of the SUBSTITUTE Function in Excel
74.1K viewsApr 17, 2018
YouTubeComputergaga
3:59
Google Sheets - Use ARRAYFORMULA Instead of Repe…
100K viewsJan 16, 2021
YouTubeProlific Oaktree
19:30
Excel: How to Create Array Formulas
2K viewsDec 12, 2019
YouTubeChester Tugwell
3:46
How to use VLOOKUP with an Excel Table
69.8K viewsApr 27, 2018
YouTubeExceljet
5:03
How to use the LOOKUP Function in Excel
894.8K viewsAug 20, 2013
YouTubeComputergaga
3:13
How to use the DSum function in Excel
88.5K viewsJun 5, 2017
YouTubeBarb Henderson
3:28
How to Create Array Formulas in Excel
122.3K viewsFeb 28, 2018
YouTubeVertex42
3:25
How to Create Dynamic Named Ranges in Excel
28.8K viewsJul 8, 2021
YouTubeExcel 10 tutorial
23:17
Google Sheets ARRAYFORMULA, Introductions to Arrays, ARRAY_C…
278.6K viewsOct 25, 2017
YouTubeLearn Google Sheets & Excel Spreadsheets
7:01
Excel Dynamic Arrays (How they will change EVERYTHING!)
779.3K viewsOct 18, 2018
YouTubeLeila Gharani
See more videos
Static thumbnail place holder