Uploaded September 2026 | Updated November 2026, 3 days ago
Download the Excel workbook I used in the video: excelcampus.com/functions/list-arrays-in-cells
Excel's newest update introduces lists in cells, collapsed arrays, nested arrays, and four brand new functions that make filtering and data lookup more powerful than ever.
This tutorial walks you through how to create lists in cells with Ctrl+J, filter by individual list values, and use the new HAS, HASALL, HASANY, and FLATTEN functions in real-world scenarios.
You will also learn how to collapse FILTER function results into a single cell using curly braces, and how to perform calculations on multi-dimensional arrays in cells.
NOTE: These features are in beta and currently available to a portion of users on the Beta channel for Microsoft365.
Additional Resources:
📰Subscribe to our free Excel Pro Tips Newsletter:
excelcampus.com/free
🧠Latest Free Masterclass on Excel & AI: excelcampus.com/blueprint-masterclass
▶️Related Videos:
Excel Filter Tip: Use Filter To Return Multiple Values Horizontally: youtu.be/tnK3cnrxbrk
Xlookup In Excel: Explained In 3 Minutes: youtu.be/txK0C6SkaMg
Dynamic Array Formulas And Spill Ranges: How To Use Them In Excel Tables: youtu.be/irR9bUKzTw8
3 Quick Ways To Combine Text In Excel - Formulas: youtu.be/kD1u7AehsAo
0:00 Introduction
0:34 Lists in Cells Feature (Ctrl+J)
1:39 Filtering Individual List Items
2:45 The HAS Function
3:23 HASALL and HASANY Functions
4:19 Using Lists within Formulas
4:58 Collapsing Lists and Arrays (Curly Braces)
6:18 2D Arrays in Cells
7:17 Calculations on Cell Arrays
8:06 Nested Arrays and Drill-down
8:45 FLATTEN Function
9:18 Conclusion and Outro
Download the Excel workbook I used in the video: excelcampus.com/functions/list-arrays-in-cells
Excel's newest update introduces lists in cells, collapsed arrays, nested arrays, and four brand new functions that make filtering and data lookup more powerful than ever.
This tutorial walks you through how to create lists in cells with Ctrl+J, filter by individual list values, and use the new HAS, HASALL, HASANY, and FLATTEN functions in real-world scenarios.
You will also learn how to collapse FILTER function results into a single cell using curly braces, and how to perform calculations on multi-dimensional arrays in cells.
NOTE: These features are in beta and currently available to a portion of users on the Beta channel for Microsoft365.
Additional Resources:
📰Subscribe to our free Excel Pro Tips Newsletter:
excelcampus.com/free
🧠Latest Free Masterclass on Excel & AI: excelcampus.com/blueprint-masterclass
▶️Related Videos:
Excel Filter Tip: Use Filter To Return Multiple Values Horizontally: youtu.be/tnK3cnrxbrk
Xlookup In Excel: Explained In 3 Minutes: youtu.be/txK0C6SkaMg
Dynamic Array Formulas And Spill Ranges: How To Use Them In Excel Tables: youtu.be/irR9bUKzTw8
3 Quick Ways To Combine Text In Excel - Formulas: youtu.be/kD1u7AehsAo
0:00 Introduction
0:34 Lists in Cells Feature (Ctrl+J)
1:39 Filtering Individual List Items
2:45 The HAS Function
3:23 HASALL and HASANY Functions
4:19 Using Lists within Formulas
4:58 Collapsing Lists and Arrays (Curly Braces)
6:18 2D Arrays in Cells
7:17 Calculations on Cell Arrays
8:06 Nested Arrays and Drill-down
8:45 FLATTEN Function
9:18 Conclusion and Outro