Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
=COUNTA(UNIQUE(FILTER(A1:A8,COUNTIF(A1:A8,A1:A8)>1)))
First duplicate occurrences count
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous
I want to count the first duplicate occurrence in a list using single excel formula
In the below e.g I would get the count as 2
For now I am counting distinct in the range A1:A8 then minus the unique (5-3=2). Two formulas were used to find the first duplicate occurrences count.
Note: duplicate occurrence can repeat from 2 to 100 times.
Microsoft 365 and Office | Excel | For business | Windows
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
Anonymous
1 additional answer
Sort by: Most helpful
-
Anonymous
2024-10-30T07:55:56+00:00 This is what I was looking for to use in Filter function COUNTIF(A1:A8,A1:A8)>1.