| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
i want to delete duplicate items in a list using code.
I have a dynamic list of 2 columns wide in alphabetical order(all items are
text). The first column contains many different duplicate items (these are together as its in alpha order), the second column's items are all unique. I wish to delete the first of each of the duplicate items and close all gaps in order to reduce the length of the list. I am using Excel 2002. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Color Code Duplicate items. | Excel Discussion (Misc queries) | |||
| Lookup duplicate items in a list | Excel Worksheet Functions | |||
| Display only duplicate values and delete UNIQUE Items | Excel Discussion (Misc queries) | |||
| Check for duplicate items and delete them | Excel Discussion (Misc queries) | |||
| Checking for duplicate items in list | Excel Worksheet Functions | |||
![ndm berry[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
