So in my previous post I was banging on about the new Dynamic Array formulas only fairly recently released to Office 365 Excel.  I reckon FILTER() is the star but as I used it, I became a little disappointed as …

Use new FILTER() formula and retrieve only the columns you want Read More »

Tagged with: ,

The new Dynamic Array functions are now in Office 365 Excel!  I have been playing around with some of them namely FILTER, UNIQUE and SORT which are awesome! Excel MVPs have helped us all with a ton of videos and …

Taking the new Dynamic Array functions out for a spin Read More »

Tagged with: , , , , ,