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.

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

Functions are the driving force of any Microsoft Excel spreadsheet, generating a single value or an array of results based on ...

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

Master Excel’s FILTER function to simplify data filtering, save time, and tackle complex datasets with ease. Learn advanced techniques now!

Excel's filtering feature is helpful, but add a bit of creativity and it becomes much more. Susan Harkins explains.

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.

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.

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

Microsoft Excel offers several tools you can use when you need to fill a column with the same text or numbers. Instead of completing each cell manually, you can quickly fill in the entire column ...