Filter Duplicates in Excel. Next Go to Data select. Select Use a formula to determine which cells to format.
Get a data set.
You might want to include or exclude the first instance when counting duplicates. First enter some dummy data into a blank Excel spreadsheet. How to Count Duplicates in Excel. Choose the cells from where you want to find duplicate values.