[thelist] OT -deleting dupLicates in excel document

Ed McCarroll Ed at ComSimplicity.com
Thu May 5 11:34:50 CDT 2005


> Is there a relatively quick way to get rid of the duplicates in
> excel without doing in manually?

If your list is one address per line, this is how I'd do it:

1. Sort your worksheet on the column where the duplications are most
   clear.  Let's call the column D.

2. Insert a column E, and in cell E1, put this formula:
   "=IF(E1=E2,"X","")

3. Copy that formula down through all the rows.  You will now see an
   "X" next to each duplicated address.

4. Copy the column you just added and "Paste Values" back into the
   same column.  Then "Sort Descending" on that column.  This will
   bring all the duplicates to the top of your sheet.

5. Delete those rows.

HTH

----------------------------------------------------------------------
Ed McCarroll                                       EdMcCarr at CDrewU.edu
IS Programmer/Analyst                                   (323) 357-3431



More information about the thelist mailing list