The following is Chip pearsons well-know Delete Duplicate Rows macro. Have used it for a long time on Excel 2003, 2007 and 2010. Works with CSV files or XLS files.
We load up a blank sheet with macro, open that, then minimize that file. For using with all other work files select Across all Open Workbooks on the working files When trying this same macro with same method with Macintosh Excel 2011, the macro runs, but does not delete the obviously duplicate rows. We are using same text CSV files and XLS files on the Mac. It will run but always reports 'Deleted 0 Rows' and there are duplicate rows Public Sub DeleteDuplicateRows ' ' DeleteDuplicateRows ' This will delete duplicate records, based on the Active Column. That is, ' if the same value is found more than once in the Active Column, all but ' the first (lowest row number) will be deleted. ' ' To run the macro, select the entire column you wish to scan for ' duplicates, and run this procedure.
Preview: Displays a preview of your document in the Mac OS X Preview application. Adobe Reader or Adobe Acrobat may intercept this action. Repeat Titles: Displays the Sheet tab of the Page Setup dialog. Gridlines: Selecting this check box prints all the lines between the rows and columns. Headings: Prints row numbers and column letters. (Note that the examples file does not work 100% with Mac Excel 2011, because the. Copy relation-for-excel-200.xlam into the add-in folder of Excel. You apply all relational algebra operators select, project, extend, union, difference, join. RelCell(rel as String, row as integer, col as Integer, Optional Numeric As Boolean.