BYROW replaces thousands of table formulas with one spill formula, making spreadsheets leaner and much more robust.

The VLOOKUP function in Excel is an incredibly powerful and versatile tool for data retrieval and analysis. It allows you to efficiently search for a specific value in one column of a table and return ...

Open an existing table or create a new table. In this tutorial, we want to find Barbie Extra Dolls sales from the ninth to sixteenth of January. Below the table, you have created. Create a mini table ...

Discover 15 modern Excel functions for 2026, including Group By and Scan, so you speed up your workflows, summaries and ...

Over the last few months, I’ve written several articles about Excel’s newish dynamic array functions. In many cases, they can replace older, more complex expressions. The new functions do all that ...