| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Deleting ALL duplicates using Pearson's code
On this site, http://www.cpearson.com/excel/deleting.htm, Pearson gives
an example on how to delete duplicate rows. Does anyone know how the code can be changed to delete ALL rows. Ex - Column A 1--delete 2--delete 3 1--delete 4 5 6 2--delete ** I would like the code to delete all the 1s and 2s. Thank you Mike |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Make Change Case in Excel a format rather than formula | Excel Worksheet Functions | |||
| Error trapped only while stepping through the code - Not triggered when run | Excel Discussion (Misc queries) | |||
| Opening a file with code without a set file name | Excel Discussion (Misc queries) | |||
| Opening a file with code without a set file name | Excel Discussion (Misc queries) | |||
| Finding and Deleting duplicates in a column | Excel Worksheet Functions | |||
Threaded Mode
