Get our FREE VBA eBook of the 30 most useful Excel VBA macros.

Automate Excel so that you can save time and stop doing the jobs a trained monkey could do.

Claim your free eBook

Recent Blog Posts

Formula Firewall in Power Query How to fix the Formula.Firewall error in Power Query (2 ways)
Advanced dynamic array formula techniques Advanced dynamic array formula techniques (3 methods)
0038 Using dynamic arrays with other Excel features How to use dynamic arrays with other features (7 scenarios)
RANDARRAY Function RANDARRAY function in Excel (How to + 4 Examples)

SEQUENCE Function SEQUENCE function in Excel (How to + 5 Examples)
FILTER Function FILTER function in Excel (How to + 8 Examples)
SORTBY Function SORTBY function in Excel (How to + 6 Examples)
SORT Function SORT function in Excel (How to + 6 Examples)

UNIQUE Function UNIQUE function in Excel (How to + 6 Examples)
Dynamic Arrays in Excel Dynamic arrays in Excel – Everything you NEED to know
Win a ticket to Global Excel Summit
Get data from OneDrive Personal files with Power Query