| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Alter Duplicate Product ID Entries
I have a column "Product ID" which uses mixed text and numerals. The
database is huge and there are many duplicates. I want to assign a new Product ID to the duplicates by adding a "-1" "-2", etc. to the duplicates. I have identified the duplicates and have them sorted by Product ID. Is there a way to automate this otherwise lengthy, phenomenally boring task? Thanks for any help you can provide. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding Duplicate Entries | Excel Discussion (Misc queries) | |||
| Duplicate Entries | Excel Discussion (Misc queries) | |||
| removing duplicate entries | Excel Discussion (Misc queries) | |||
| Removing duplicate entries. | Excel Discussion (Misc queries) | |||
| count duplicate (or, inversely, unique) entries, but based on a condition | Excel Worksheet Functions | |||
Threaded Mode
