Functions like FILTER, SORTBY, UNIQUE, XLOOKUP, and VSTACK transform static grids into real-time data systems.

Creating a list of duplicate values that’s separate from the data source is easier than ever thanks to Microsoft Excel’s FILTER() function. There are a number of ways to highlight duplicate values.

The smartest thing Excel does happens in places you can't see.

To check if a value exists in an array, we can loop through its elements. However there is another solution! You can use the INDEX () function, native to Excel and in the case of two-dimensional ...

Populating a dropdown with a dynamic list is easy thanks to Microsoft Excel’s UNIQUE() dynamic array function. Microsoft Excel’s Data Validation feature provides an easy way to create a dropdown at ...