Filter Duplicate Rows

Hi,

I知 having a worksheet with 8 columns of data, where my data starts from row 6. Meaning, the column the headings start from row 5.

I知 trying to figure out a code which would filter all the duplicate rows (depending upon the duplicate values on column A); with the click of a button.

Suppose If I知 having C 12345 in row 7 & C 12345 in row 50. The click of the macro button would filter these two rows.

Any help on this would be kindly appreciated.

If that cannot be done in Excel, can all the rows with unique record be filtered?