[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