Duplicate fields

[Dook]

How do you (or can you) use Excel to automatically find duplicate values within a column of numbers.

Pease say yes 'coz I'm tearing my hair out.

 

[ThePencilQueen]

I usually just create a pivot showing all the numbers and a count of each number then sort descending by the count.

However this was my bodge method of doing this quickly for work - there is probably a much more elegent way.