| 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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Alter Duplicate Product ID Entries
So if you have:
ASDF ASDF ASDF you want ASDF ASDF-1 ASDF-2 If yes, you could use a formula like this in B2: =A2&IF(COUNTIF($A$2:A2,A2)=1,"","-"&COUNTIF($A$2:A2,A2)-1) if you wanted: ASDF-1 ASDF-2 ASDF-3 You could use: =A2&"-"&COUNTIF($A$2:A2,A2) (I like the second method.) Mike wrote: 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. -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Alter Duplicate Product ID Entries
That did it! Thanks so much. I'm sure you save me 16 hours or more of data
entry. "Dave Peterson" wrote: So if you have: ASDF ASDF ASDF you want ASDF ASDF-1 ASDF-2 If yes, you could use a formula like this in B2: =A2&IF(COUNTIF($A$2:A2,A2)=1,"","-"&COUNTIF($A$2:A2,A2)-1) if you wanted: ASDF-1 ASDF-2 ASDF-3 You could use: =A2&"-"&COUNTIF($A$2:A2,A2) (I like the second method.) Mike wrote: 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. -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Alter Duplicate Product ID Entries
Watch the mail for my bill! <bg
Glad it worked. Mike wrote: That did it! Thanks so much. I'm sure you save me 16 hours or more of data entry. "Dave Peterson" wrote: So if you have: ASDF ASDF ASDF you want ASDF ASDF-1 ASDF-2 If yes, you could use a formula like this in B2: =A2&IF(COUNTIF($A$2:A2,A2)=1,"","-"&COUNTIF($A$2:A2,A2)-1) if you wanted: ASDF-1 ASDF-2 ASDF-3 You could use: =A2&"-"&COUNTIF($A$2:A2,A2) (I like the second method.) Mike wrote: 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. -- Dave Peterson -- Dave Peterson |
| Reply |
| 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 | |||
Linear Mode
