Microsoft Excel’s Advanced Filter feature displays records that match specific criteria. You can also limit the columns returned by this feature.

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

Launch Microsoft Excel and open the spreadsheet you want to filter by multiple colors. Select the column that you want to filter. To select multiple columns, click and drag over the column headers.