How to find wich PK have duplicates

[arngue]

Hi,

I've been searching, but i don't need to know how many duplicates are, i've already know this. I need to find wich are the duplicated ones to find why is getting duplicated.

I have a very large table with 66246 rows and only one duplicate, anyone know how to find it?. tring with EXCEL crashes...

[achettipalli · Accepted solution]

Hi!

It sounds contradicting when Primary key has duplicates. However to know those duplicates one method could be:

=Aggr(If(Count(column)>1,1,0),column)

Good luck!

Avinash