Wishing my faithful readers peaceful and happy holidays.
Hope you enjoy my jumping Power Query X-mas tree: It changes his size or decoration randomly every time you press refresh: Totally auto-M-agically 😉 (No macros and no Excel formula in any cell ! )
Just 6 lines of code and 2 formatting conditions return a table with dynamic size. So if you haven’t discovered the M-agic of Power Query or Get&Transform in Excel yet, this is a good handful of code to start your discovery with!XMasTreeV2.xlsx
Data -> Refresh All or Ctrl+Alt+F5
Happy holidays & stay queryious 🙂