Microsoft 365's UNIQUE() function is a great reason to upgrade. Combine UNIQUE() and SORT() to generate unique lists with a single formula.

Adding a drop-down list in Excel is a quick and efficient way to choose predefined data. Here's how to create a drop-down list in Microsoft Excel.

Learn how to create a drop-down list in Excel without or with color using conditional formatting and data validation rules.

A list isn’t, however, a count, so in this article, I’ll show you how to use UNIQUE () to return the count of unique values, indirectly, in Microsoft Excel.

One of the most common tasks in data analysis is counting unique entries within a dataset. This process can be time-consuming and prone to errors when done manually, but Excel 365 offers a ...

Drop-down lists in Excel let you create a list of valid choices that you can select for a given field. We'll show you how to use tables, named ranges, formulas, data validation, and table styles.

You can reverse the row or column order of a list in Excel by creating reference list, a Macro, and using INDEX function. We have explained all these methods.