If your company is working with a large list in an Excel spreadsheet, take advantage of the program's built-in filter customization tools to limit the number of rows included in your filter results.

This formula will filter every fifth item in the list, starting with the first item. If you want to filter another number of rows, replace "5" with an alternate number.

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