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-excel-stuff/free-excel-templates/ A copy of the file I used https://aasolutions.sharepoint.com/:f:/s/PubliclyAvailableContent/EiKfH7Kx4uJEsrtA_g3INWAB_o6pndfZFCMswwX16lTEdA?e=nKUzax Follow me https://wyn.bio.link/ Buy my book: https://pbi.guide/