|Today I got a request to delete duplicate rows from a spreadsheet. The following code will do this.|
Note that the first loop starts from the last record and works backwards. You do this because as you delete records the loop variable stays correct. If you went forward you wouldn't know where the end was. It assumes that there are 2,139 rows in the sheet and 16 columns. The sheet could be modified to figure out the last row and last column.
The code uses two for loops and checks field by field to see if the data is a duplicate.