Excel - finding duplicate entries ?

[Snow-Munki]

Hi,

I have a spreadsheet with about 7000 rows of data, just wondering if there is a way to find out if there are any duplicates quickly ?

Thanks,

 

[Participant]

What I do is create a pivot table, then add the column field to the data section with a count parameter.

Any that are duplicated will have a count of more than 1.

Sorting alphabetically is a clunky way to do it also.

 

[div0]

You can easily filter out any duplicates by going to Data - Filter - Advanced Filter, and then ticking the 'Unique Records Only' tick box. This will auto-hide any duplicate rows.