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

Advance Filter in Microsoft Excel is easy to use. Learn how to filter data based on complex conditions in Excel the right way.

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.

If Excel filter is not working after certain row, for merged cells, on large files or on protected sheet, then see this post.

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

Creating a list of duplicate values that’s separate from the data source is easier than ever thanks to Microsoft Excel's FILTER() function.

How to apply multiple filtering criteria by combining AND and OR operations with the FILTER() function in Excel Your email has been sent Applying multiple criteria against different columns to ...

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

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