Learn how to use the TEXTJOIN function in Excel. The TEXTJOIN function can be used to combine data from a range of cells using one or more delimiters.

Excel's AGGREGATE function lets you perform calculations whilst ignoring hidden rows, errors, or other functions that appear in the data. It's similar to the SUBTOTAL function but provides more ...

The UNIQUE function in Excel 365 is designed to extract distinct values from a given range of data.

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.

Populating a dropdown with a dynamic list is easy thanks to Microsoft Excel’s UNIQUE() dynamic array function.

This month’s column shows how to use the remarkably versatile AGGREGATE function in Excel.

Are you wondering how to use the Excel FILOTER function with multiple criteria? We have detailed guide on how to easily use the Filter function in Excel using the AND and OR operators.

The lookup function in Excel can save you a lot of time and effort, but only if you actually know how to use its many forms and alterations.

Both function combinations will skip over any blank row and will not count towards the running total of unique values, as there is no value to be counted.

A little from column A, a little from column B: XLOOKUP is the new, easier way to retrieve information across Excel spreadsheets.