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 How to fix the Formula.Firewall error in Power Query (2 ways) Advanced dynamic array formula techniques (3 methods) How to use dynamic arrays with other features (7 scenarios) RANDARRAY function in Excel (How to + 4 Examples) SEQUENCE function in Excel (How to + 5 Examples) FILTER function in Excel (How to + 8 Examples) SORTBY function in Excel (How to + 6 Examples) SORT function in Excel (How to + 6 Examples) UNIQUE function in Excel (How to + 6 Examples) 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