Take a look at RFC Tutorial - Deleting Excel Rows, Columns and Sheets. That said if you're driving excel via Win32::OLE you may be able to filter by the unique records. The text in bold is a hint, use this as the basis for a search.