Imagine you’re tasked with analyzing two datasets—one containing a list of products and another with customer segments. How do you uncover every possible pairing to identify untapped opportunities?

Q. Is it possible to sort a column in Excel using formulas rather than the Data tab’s Sort tool, so the sort process is performed automatically as I update my data? A. Excel has announced a new ...

Overview Excel remains a core tool for data analysts, and a small set of functions can handle most tasks related to lookups, ...

Microsoft 365’s UNIQUE() function is a great reason to upgrade. Combine UNIQUE() and SORT() to generate unique lists with a single formula. Lists are a fundamental part in almost any Microsoft Excel ...

The BYROW function is a powerful tool that applies a Lambda function to each row in your dataset. This function is particularly useful when you need to perform operations on a row-by-row basis. For ...

Join in on the Excel fun.

Use the RANDARRAY() dynamic array function to return random names or other text in Microsoft Excel. The recent article How to generate random letters in Excel shows you how to generate random letters.