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

Suppose you are a project manager using Excel to track your team’s tasks. You have created a database with columns like Tasks, Assignee, Status, and Due Date. Now you want to ch ...

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

Functions are built-in shortcuts for common calculations. The Unique function removes duplicates or extracts distinct items from a list.

If you need to average a list of values in Microsoft Excel that contain duplicates without including the duplicates, don't fret over a complex expression when you can easily remove those duplicates.

Learn how to count the number of unique and distinct values in a column based on data in another column using array in Microsof Excel.

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.