Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i find and delete duplicates in excel worksheet?
I have combined several mail list into one on excel workshett and have quite
a few dupicates. How can I find and delete duplicates? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i find and delete duplicates in excel worksheet?
I wasn't able to find anything in excel that would accomplish this. I had
the same problem and bought DIGDB and excel add in. I couldn't live without, it is a wonderful tool to use in exel. "mrsthickness" wrote: I have combined several mail list into one on excel workshett and have quite a few dupicates. How can I find and delete duplicates? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i find and delete duplicates in excel worksheet?
I use the following formula in a list to find duplicates. It doesn't auto
delete but helps you detect easily. Of course you need to ensure your list is sorted alphabetically and then the formula looks above and below a line for duplicate: =IF(OR(A5=A6,A5=A4),"dup",0) "DIANE K" wrote: I wasn't able to find anything in excel that would accomplish this. I had the same problem and bought DIGDB and excel add in. I couldn't live without, it is a wonderful tool to use in exel. "mrsthickness" wrote: I have combined several mail list into one on excel workshett and have quite a few dupicates. How can I find and delete duplicates? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
in workbook, where is delete worksheet | Excel Worksheet Functions | |||
How can I use find and replace to delete a word in Excel? | Excel Discussion (Misc queries) | |||
Can't find macro in an Excel file to delete it | Excel Discussion (Misc queries) | |||
How do I find duplicate rows in a list in Excel, and not delete it | Excel Discussion (Misc queries) | |||
Weekly Transaction Processing | Excel Worksheet Functions |