Awesome new functions: FLATTEN, HAS, and now Lists in cells! @AccessAnalyticLearn
Awesome new functions: FLATTEN, HAS, and now Lists in cells!  @AccessAnalyticLearn
Uploaded September 2026 | Updated November 2026, 3 hours ago
👩🏻‍🎓Do you want to learn Pro-Level Excel techniques or Power BI?
Check out our amazing course at accessanalytic.thinkific.com


Micrisoft docs:

techcommunity.microsoft.com/blog/microsoft365insiderblog/put-multiple-values-in-one-cell-with-lists-and-arrays-in-excel/4559395



📗Prefer reading a book to learn then check out "Power BI for the Excel Analyst" by Wyn Hopkins
https://pbi.guide/book/


The team at Access Analytic develop Power BI and Excel solutions for clients in Australia and deliver training around the World.
🌐 https://accessanalytic.com.au/


🫶🏻 Join the channel to get access to perks:
youtube.com/channel/UCvD2rJJrp0aS48-KCk0eMHQ/join


00:00 Introduction
00:18 Why XLOOKUP Arrays Were Previously a Problem
01:18 XLOOKUP Now Returns In-Cell Lists
01:58 Using the New FLATTEN Function
02:14 Introducing the HAS Function
03:38 HAS, HASANY and HASALL Explained
05:31 What Are Excel Lists?
06:49 Filtering Individual Items Inside Lists
08:07 Referencing List Items with INDEX
08:44 When Lists Are Useful (and When They're Not)
09:17 Final Thoughts on FLATTEN and HAS Functions
Awesome new functions: FLATTEN, HAS, and now Lists in cells!When is a space not a space?  When Power Query Clean Fails.Messy data ruins everything before you even startFaster SharePoint folder consolidation using Incremental Refresh (see warning in the notes)Excel Drop Down Asterisk HackWho cares about data validation?Excel or Power BI?How good is Copilot at Power Query ?Are you a 7?💥 NEW Power BI + PowerPoint Integration: Full Demo & Tutorial!How to prevent a hidden Power BI page being printedHow to get 6 million views on YouTube [satire]
Access Analytic Learn |

Awesome new functions: FLATTEN, HAS, and now Lists in cells!

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER