How to count consecutive duplicates in Excel?
To count the duplicates in an Excel column may be easy for you, but have you ever tried to count the consecutive duplicates yet? In other words, it will count continuous duplicates and recount it from 1 if there is a break between the duplicates as below screenshot shown.
Recommended Productivity Tools for Excel
Office Tab: Bring powerful tabs to Office (include Excel), just like Chrome, Safari, Firefox and Internet Explorer. Save you half the time, and reduce thousands of mouse clicks for you. 30-day Unlimited Free Trial
Kutools for Excel: Save 71% of your time and solve 82% Excel problems for you. 300+ advanced tools designed for 1500+ work scenario, make Excel much easy and increase productivity immediately.60-day Unlimited Free Trial
To count consecutive duplicates, just need to apply a simple formula.
1. Select an adjacent cell, B1 for instance, enter 1. See screenshot:
2. In the next cell below 1, B2 for instance, enter this formula =IF(A2=A1,B1+1,1), then drag autofill handle down to the cells to apply this formula. See screenshot: