Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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...
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
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