This a post about a handy little formula I came up with on a job last week in order to test formulas from a client’s solution, against a list of specific ‘newish’ Microsoft 365 formulas like LAMBDA() and TOCOL() not present in his version. I needed to replace these formulas with older formulas. How I …
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 it seemed like you could only return ALL the columns in the range you are …
Use the new FILTER() formula and retrieve only the columns you want Read More »
The new Dynamic Array formulas 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 posts out there introducing these new functions. Just Google Excel new Dynamic Array formulas and …
Taking the new Dynamic Array formulas out for a spin Read More »