Referencing Dynamic Arrays with Tables
⬇️Excel tips and tricks throughout this extended tutorial⬇️
Dynamic Array Functions: UNIQUE, SORT, FILTER
Tables
Flagging hidden rows using AGGREGATE
Formatting Slicers
Named Ranges
The AA Toolbar can be downloaded free from here https://accessanalytic.com.au/free-ex...
A copy of the file I used
https://aasolutions.sharepoint.com/:f...
Follow me
https://wyn.bio.link/
Buy my book:
https://pbi.guide/