| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I delete dublicate cells?
I have a mailing list of over 6000 set up in excel. When I sort by street
adresses I notice that the are quite a few that are duplicated. Is there a quick way to delete dublicate cells and the lines they rest in? |
|
#2
|
|||
|
|||
|
Hi,
See http://www.cpearson.com/excel/deleting.htm - DeleteDuplicateRows "Retroactive78" wrote: I have a mailing list of over 6000 set up in excel. When I sort by street adresses I notice that the are quite a few that are duplicated. Is there a quick way to delete dublicate cells and the lines they rest in? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to delete data in 'green' cells only | Excel Worksheet Functions | |||
| Delete shaded cells | Excel Discussion (Misc queries) | |||
| Locate and delete specific cells | Excel Discussion (Misc queries) | |||
| Delete contents of unprotected cells in workbook | Excel Worksheet Functions | |||
| How do you delete one cell from a range of protected cells | Excel Worksheet Functions | |||
Linear Mode
