I'll throw something out all of you weigh in on it and see if it will do what's needed. Select the entire sheet Except the row containing the headers. Next go to Sort. choose Column A (or whatever the header name is in column A.
that will put all duplicated items together. select the rows that have the duplicated names. the Go to Edit Delete and choose to move up. (make sure you leave one you will have to choose desired one to keep.) If it is a Half-backed idea say so. From the way its being explained that would be the way I would do it. If my reply has helped, mark accordingly - Helpful or Answer Phillip M. Jones, C.E.T.
This piece of code will create a list of unique values and copy into another cell. So create unique list.
You have to specify where your list starts, and where you want to copy to. You can do this by changing the fromCell and toCell variables. I hope this helps.
![Maximum rows in excel Maximum rows in excel](/uploads/1/2/5/3/125386872/471887104.jpg)
Figure 3: Follow these steps to highlight duplicate values in Excel 2003. You can access the Conditional Formatting feature from either the menu bar or from Excel’s ribbon in Excel for Mac 2011. If you use the ribbon, identifying duplicate values in Excel for Mac 2011 is identical to the steps in Excel 2007 and later.