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.

Click on the heading of the column you want to evaluate for duplicates. Click and drag from one heading to the next to select more than one column. Hold down the "Ctrl" key and click to select columns ...

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