How to count duplicates in Microsoft Excel There are various ways that duplicates can occur in Microsoft Excel. Check out one method for counting duplicate records in Excel.