I have data in 20 Columns with about 2000 rows.

I have applied an Auto Filter to the columns.

The spreadsheet has multiple data entries in the rows and i want to somehow delete those multiple entries, leaving just one.

Eg: Row 545 has identical data in to line 546 and 547. I'd like to delete two of those rows to leave one.

Is there a simple way of doing this than picking the rows to delete out all individually say through a filter?


By the way. I'm running both Excel 2010 (Windows) and Excel 2011 (Mac).

Thanks