MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel 2019: Understanding Array Constants

September 12, 2019 - by Bill Jelen

Excel Understanding Array Constants. Photo Credit: Dan Gold at

There are several dynamic array that get better with an array constant. Here is a simple way to understand them. A comma inside an array constant means to move to the next column. A semi-colon means to move to the next row. How do you remember which is which? The semi-colon on your keyboard is located near the Enter or Return key which also goes to the next row.

continue reading »

More Reading

Excel Filter with a Formula. Photo Credit: Ben Wicks at

Excel 2019: Filter with a Formula »

September 11, 2019 - by Bill Jelen

The FILTER function is new as part of the dynamic arrays feature. There are three arguments: array, include, and an optional [if empty].

Excel Sorting with a Formula. Photo Credit: John Such at

Excel 2019: Sorting with a Formula »

September 9, 2019 - by Bill Jelen

Sorting data in Excel is easy. Unless, you are building a dashboard for your manager's manager. You can't ask that person to select C3, go to the Data tab and click the AZ button every time they want an updated report. The new SORT and SORTBY functions allow you to easily sort with a formula.

read more articles »

IMA Data Analytics Leveraging Excel

Featured Products

MrExcel LIVe

MrExcel LIVe »

A book for people who use Excel 40+ hours per week. Illustrated in full color.

The Absolute Guide to Dashboarding & Reporting with Power BI

The Absolute Guide to Dashboarding & Reporting with Power BI »

Learn Power BI Dashboarding Techniques by Watching A Pro!

Excel JavaScript UDFs Straight to the Point

Excel JavaScript UDFs Straight to the Point »

JavaScript custom functions - UDFs can be used like any other native functions or UDFs in Excel. This book shows the process of creating JavaScript UDFs in Excel Developer Preview for Office Insider program subscribers.

Supercharge Excel When You Learn to Write DAX For Power Pivot

Supercharge Excel When You Learn to Write DAX For Power Pivot »

Hands-on book to learn and master the DAX language!

Microsoft Excel 2019 Inside Out

Microsoft Excel 2019 Inside Out »

Dive into Microsoft Excel 2019–and really put your spreadsheet expertise to work. This supremely organized reference packs hundreds of timesaving solutions, tips, and workarounds–all you need to make the most of Excel’s most powerful tools for analyzing data and making better decisions.

Excel 2019 Business Basics & Beyond

Excel 2019 Business Basics & Beyond »

Are you tired of tracking financial elements of your business manually, do you have to prepare staffing schedules by hand, or do you simply want to know how to get more information from your business data? Learn how to harness your business data and put it to use for you.

see more products »