Macro for duplicate records

Hi Everyone,

I have a spreadsheet with over 60K entries and it grows on a monthly basis. I'm looking for a macro that will search a single column and return all entries that are duplicates. I have attached a workbook as an example to the data I will be viewing.

The macro will need to look under Column F and create a list (can be in the same sheet or separate sheet) of all the entries that have duplicate serial numbers.

Thanks in advance for your help.