When you need to get rid of duplicates in a column, Excel's advanced filtering options will do the trick. This quick walk-through shows how it's done.

How do I use advanced filter unique records only in Excel? Under the Data tab, select the Advanced Filter, and then ensure the filter is set to Unique records only.

You can filter data in Excel based on either certain parameters in columns or over the whole sheet, and you can later unfilter the sheet.

The FILTER function has all the filtering power of the venerable filter feature but can perform more tasks, including setting up automated filters and showing results where the user wants them to be ...

One typical application for Excel is to find information in a list of data. The simplest way to do this is filtering the data so that Excel does the work of finding the pertinent information for you ...

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.

Click the arrow located in the column header at the top of the list you want to filter. Excel adds filtering controls to column headers automatically.

Learn how to use Excel FILTER, XLOOKUP, and SUMIFS functions to streamline workflows and make smarter data-driven decisions.

This illustrated walk-through (with a demo worksheet) shows how easy it is to create a multi-column search solution using validation lists and conditional formatting.

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 ...

Easy one for the Excel Gurus (best way to filter/sort unique item counts from a column of mixed string formats) ...