Filtering duplicates

[stevemac]

I have a spreadsheet that contains over 5000 entries in it. The information is Column A: Client Number, Column B: Surname, Column C: Firstname and Column D: Yes/No.

Normally I have to print this huge spreadsheet off and manually highlight the duplicate enties (there are hundreds of them).

Does anyone know an easy way to use a filter that only shows the duplicates or non-duplicate entries? This will save me a huge amount of time.

Regards,

 

[yosi]

add a column with the formula
=IF(COUNTIF(A:A,A1)>1,1,0)
assuming you filter column A
now filter from column A + filter 0 from the new column

 

[Brian from Maui]

This maybe of interest

http://www.mrexcel.com/board/viewtopic.php?topic=8659&forum=2

 

[bolo]

you could use the advanced filter. found in Data, filter,advanced filter. Tick the unique records box select ok. THat should do the trick

regards

 

[stevemac]

Tried the fix from Yosi and worked an absolute treat!
Advanced filter also worked.

Thanks again Guys.