Replicate Remove Duplicates icon using a macro in Excel Mac 2011

How do I get the action related to the Remove Duplicates icon in Mac Excel 2011 replicated in a macro? The reason I am asking is because the Record Macro function does not record the actions linked to this icon.

I have a relatively large spreadsheet where I want duplicates removed that meet multiple criteria (eg only records where the date, name and address are unique must be kept but the amount can differ). This is what the Remove Duplicates icon allows you to do by selecting the fields used to filter and identify unique records.