The total depth argument in the GROUPBY function in Excel is used to display subtotals in the output data, which are formatted in blue. The output of a GROUPBY formula that sorts the data by column 2.

Excel has over 475 formulas in its Functions Library, but we've selected the most popular, from date and time functions to mathematics and simple data manipulation.

In such cases, Excel's LOOKUP function can be extremely useful. It allows you to search for a value in a range of cells and return a corresponding value from another range.

Excel has a versatile If, Then function built right into it. We’ll show you how to use the IF function in Excel with a number of helpful examples.

As you can see in the screenshot below, the same UNIQUE formula is entered in cell E2, including defining the same array (B2:B101). All that was to be done additionally was to add parentheses around ...

Data can be overwhelming, but Excel's CORREL function helps you cut through the noise. Calculating the correlation ...

This column introduces PIVOTBY, a new Excel function that may let you say bye-bye to PivotTables. Skip to content. ... E501 (which includes all the amounts) as the values, and SUM as the function. The ...

Microsoft Excel’s new text function TEXTSPLIT() is Excel’s TEXT TO COLUMNS feature in a formula and a bit more.

Excel’s XLOOKUP() function is available in Microsoft 365 and Excel 2021, and Excel for the web. For your convenience, you can download the demonstration .xlsx files .