Delete Duplicate Rows

[Mark F]

Hi Guys

I have tried to search Mr Excel and can't quite find what I am looking for. I have tried a few examples that haven't worked for whatever reason - me probably

I have a sheet that has around 58000 rows with 5 columns.

I need to delete all of the duplicates of rows where there is a duplication in column C - in other words leaving just one entry of that row

This is a one off job so the number of rows is fixed as such

There are no blanks in any other 5 columns

Thanks for any help

Mark[/img]

 

[just_jon]

Thanks, Nate & Ponsy -- glad to know we had not discovered another "feature" like fairwinds did!