D
Dougie13
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 t
somehow delete those multiple entries, leaving just one.
Eg: Row 545 has identical data in to line 546 and 547. I'd like t
delete two of those rows to leave one.
Is there a simple way of doing this than picking the rows to delete ou
all individually say through a filter?
By the way. I'm running both Excel 2010 (Windows) and Excel 2011 (Mac).
Thank
I have applied an Auto Filter to the columns.
The spreadsheet has multiple data entries in the rows and i want t
somehow delete those multiple entries, leaving just one.
Eg: Row 545 has identical data in to line 546 and 547. I'd like t
delete two of those rows to leave one.
Is there a simple way of doing this than picking the rows to delete ou
all individually say through a filter?
By the way. I'm running both Excel 2010 (Windows) and Excel 2011 (Mac).
Thank